Enlarging Text Box capacity. 2

[davidmulcair]

I'm using a text box for a "Comments" field.. I get the error that there is too much there... Is there any way to increase the txt box capacity? Is there another solution to the "Comments" field?

David Mulcair

 

[Maquis]

change your field from a text field to a memo field in the table. Maq B-)
<insert witty signature here>

 

[MindCooler]

Try changing the Data Type in the underlying table to memo rather than Txt. You will then not be limitted to 256 charachters more like 56000.

 

[davidmulcair]

Thanks !

 

[BBaggins]

Is your limitation with the database field, or with the textbox itself? Do you get the error when you save the data or when you display it?

Although you can put as much text as you want into a memo field, you still have a limit as to what can be displayed in a standard textbox (maybe as much as 62kb, but probably less).

One solution is to use the RichText control instead of the standard textbox. It will display an unlimited amount of text.

Also, consider the fact that every non-null memo field takes up at least 2Kb of disk space, even if it only contains an empty string. Consider alternate methods of storing your comments that aren't as wasteful.