Textbox Question

[Guest]

I have a form that allows users to enter the results of various experiments.
I used a textbox to do this. These are then stored as a field in the user's
record. My problem is this: the textboxes are limited to 255 characters (the
maximum size of the field they are bound to in the table). Many users need
more than 255 characters to explain their conclusions. I need a way for a
user to be able to type more than 255 characters into a control on a form and
then have that info stored as part of their record in a table. Is there an
elegant way around this?

Nick

 

[Guest]

change the field type to "memo". It will have unlimited length, but cannot be
indexed or searched by context.