Text

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

Guest

I have a form I created and the field will only let me type in 20 characters,
how do I change it so I can enter the full text??

thanks
 
Open the table in design view. Click on the field. In the lower part of
the window, adjust the Field Size.
 
I tried this and it does let me increase the "size" of the field but I still
can't add more characters in that field in the form view. The box is bigger
but I am still limited on how much I can type in that field and it didn't
increase at all when I made the field bigger.

thanks,
cheryl
 
We need to get some terminology straightened out. A table contains fields
in which data are stored. A table is an interface that lets you work with
the data. If you have a form that uses a table or query as its record
source, controls such as text boxes, check boxes, and combo boxes may be
bound to fields in the underlying table. I think you are using "field" when
you mean "control". Changing the field size in *table* design view will not
change the size of a text box bound to that field, so I am guessing that you
changed the size of the control (text box), not of the field. If you
changed the field size, the text box would accept more characters (unless
there is an input mask, code, or other things in place that would limit what
you can put into the field or control), regardless of its physical size.
Again, open the *table* in design view. You will see the headings Field
Name, Data Type, and Description at the top. The fields in your table are
in the Field Name column. Click on the field in question, and look in Field
Properties below the listing of fields. Click the General tab if it is not
selected, and look for Field Size at the top of the list on the General tab.
 
Glad to hear you got it working. The terminology primer seems to have
cleared it up.

I need to correct something I said. "A table is an interface that lets you
work with the data" should have been "A form is an interface that lets you
work with the data". You should not work directly with table data, except
during develoment. Taking it a step further, reports are for printing, or
in some cases for viewing data with which you do not need to interact.
 

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

Back
Top