Text field (255 char) not large enough! Any ways to get it around?

[Doraemon]

I have a textbox named "Remarks" in the form which is bounded to the Text field "Remarks" in a table.

My problem is:
Text field can only store 255 characters. But the value input in "Remarks" field will sometimes exceed that length.

I would like to ask what can I do so that the value in the textbox, no matter how large it is, can be stored in the table. Should I use the Memo instead of Text for the "Remarks" field?

Thanks in advance for your help.

 

[SgtJarrow]

Memo fields will accept approx 65K characters when type in and are only restricted by size of database when entered programatically. One thing to remember about memo fields is that they can be sorted or search against very easily....but yes, they will hold your remarks better than a text box.

****************************
When the human body encounters disease it raises its temperature making it uncomfortable not only for the body but also for the disease. So it global warming the Earth's way of saying we are not wanted?

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com