Increase Maximum Length of a database item without increasing its size
793630Aug 25 2010 — edited Sep 1 2010Case- There is a database item, which will now solve dual purpose. It allows only 9 charcaters to be entered at present.I need to modify this field and allow more than 9 characters (Only for display purpose) internally this >9 characters will find out an equivalent 9 character value and assign back to this item.
In forms builder it easy, pop-up the property pallette and increase the maximum length of that database item.
I do not see this option in designer. I can only see the item "Width" which will only physically stretch this item more, I do not want this. I want the size to remain the same but length should be increased to allow more than 9 characters.
Please help as I have been scratching my head since a week and finally thought of posting this on forums.