Increase the field size

[Guest]

How can I increase the no. of characters that can be entered in a field? It
the table for this particular field I have assigned in properties the field
size as 255 as that is the max it will go. So in my form I can type in
onlyabout 5 lines can I increase it in any way?????

 

[Rick Brandt]

How can I increase the no. of characters that can be entered in a
field? It the table for this particular field I have assigned in
properties the field size as 255 as that is the max it will go. So in
my form I can type in onlyabout 5 lines can I increase it in any
way?????

Change DataType from Text to Memo.

 

[Jason Rice]

Switch the field data type to "Memo". This will allow 65,535 characters in
according to the information that I have on the 2002 and 2003 versions.

 

[Al Camp]

FC
Define the field as a Memo field in your table.
hth
Al Camp