Problems with field size limits in the form
Posted on 2004-09-17
I'm having trouble with this one:
I've a form, which has a field called accountNumber.
This field has the following properties:
Type = Text
Size is limited to 13 bytes
Allow Multiple values is checked
in the Multiple Value Options the following is selected:
Seperate values when user enters Comma, Semicolon, Newline
Display seperate values with Semicolon.
Now I've a situation where I need to store more than 5000 accountnumbers (remember each account number is 13 bytes long)..
But the maximum i could store is some where around 2100 values. Is there an alternative for this one.