Text box filed size limit

K

Kelly

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.
 
D

DS NTE

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
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.
 
J

John Vinson

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.

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!)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top