Text box filed size limit

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

Guest

I am using a form that has uses a text box to hold the description of the work needed from a customer work request. Well it will only let me type in so many characters then it just stops. I can't find any property for the Field Size to allow me to put in more text. Any help woould be greatly apretiated.
 
Use a memo-field, it can hold 65536 characters. A text-box holds just 256.

knut
Kelly said:
I am using a form that has uses a text box to hold the description of the
Click to expand...
work needed from a customer work request. Well it will only let me type in
so many characters then it just stops. I can't find any property for the
Field Size to allow me to put in more text. Any help woould be greatly
apretiated.
 
I am using a form that has uses a text box to hold the description of the work needed from a customer work request. Well it will only let me type in so many characters then it just stops. I can't find any property for the Field Size to allow me to put in more text. Any help woould be greatly apretiated.
Click to expand...

The limit does not apply to the Form - it's just a window; the data is
in the Table upon which the form is based.

If it's stopping at 50 characters, open the Table in design view and
change the size of the text field from the default 50 to 255 (the
maximum for a Text field). If 255 isn't enough, change the field type
from Text to Memo - that'll give you 64KBytes (actually a gigabyte if
you use VBA code to load data into the field, not that you'ld want
to!)
 
Back
Top