C
Croque
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
how do I change it so I can enter the full text??
thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
BruceM
Open the table in design view. Click on the field. In the lower part of
the window, adjust the Field Size.
the window, adjust the Field Size.
C
Croque
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
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
B
BruceM
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.
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.
C
Croque
Thank you, Thank you, Thank you.....that worked!!!
v/r,
Cheryl
v/r,
Cheryl
B
BruceM
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.
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.