Field Too Small

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field for notes on all my forms. It is just a regular text box, however I have enlarged it so I can fit several notes. I'm getting an error, saying that my the field is not large enough, even though I am not halfway through the box yet(I hope that makes sense). I tried selecting "yes" by the "field can grow" box, but that did not work. I'm not reall sure how to fix this. Any help would be much appreciated. Thanks.....
 
Check the properties for that field on the table that holds the data. Make
sure you've allowed for enough characters. (I think the default is 50
characters). I usually set my notes fields to memo type rather than text.
If I use text, I'll set it to 255 characters.

-Lauri


Andy said:
I have a field for notes on all my forms. It is just a regular text box,
however I have enlarged it so I can fit several notes. I'm getting an
error, saying that my the field is not large enough, even though I am not
halfway through the box yet(I hope that makes sense). I tried selecting
"yes" by the "field can grow" box, but that did not work. I'm not reall
sure how to fix this. Any help would be much appreciated. Thanks.....
 
Andy said:
I have a field for notes on all my forms. It is just a regular text
box, however I have enlarged it so I can fit several notes. I'm
getting an error, saying that my the field is not large enough, even
though I am not halfway through the box yet(I hope that makes sense).
I tried selecting "yes" by the "field can grow" box, but that did not
work. I'm not reall sure how to fix this. Any help would be much
appreciated. Thanks.....

Text fields are limited to 255 or less characters, The size of the
visible box makes no difference.

You can also use a memo field type. I suggest you try and avoid the us
of the memo field type if you can limit your text. If not use the memo
field. You will not run out of room there.
 
Back
Top