How do I change the number of spaces in a field

K

karly

I am using a database created by someone else. I need to be able to type
more than the allowed characters in the column field. Don't know how do
this, haven't used access much.
 
T

tina

if the field in the table is Text data type, you can change the field's
FieldSize property in the table's design view.

you need to proceed with caution, however. since you didn't create the db,
you don't know if certain functionality is predicated on that field being a
specific size - if that's the case, then entering a longer string may
"break" the functionality. suggest you review the macros and/or VBA code for
actions that are based on that field, and review any form/report control
that is bound to that field, for input masks, formatting and validation
rules that may be impacted by a change in length.

hth
 
Top