i need help with Access field sizes

[Guest]

access will not allow me to type in more than 60 characters into a field,
even though I have changed the field in design to 255

 

[Ken Snell \(MVP\)]

Are you typing directly into a table (I hope not)? Are you typing into a
textbox on a form that is bound to that field? More details, please.

 

[Guest]

Is it a local table, or a table in SQL server with link to Access?
In that case you need to ReLink the table to accept the changes

 

[Van T. Dinh]

I assume you are referring to the Text data type.

If you are using Front-End / Back-End and you modify the Table Design in the
Back-End, you need refresh the linked Tables in the Front-End to pick up the
new design.

If not above, we probably need more info. on how you enter data, e.g.
Datasheet view of the Table or Form? Relevant set-up details / code on the
Form, if applicable.

 

[Guest]

Along with the other good advice, there is another possibility. Are there are
lot of fields in this table? Access has a limit of 2000 characters per record
not including OLE and Memo fields. 4000 characters UnicodeCompression
property of the fields is set to Yes. Therefore if you have a lot of data in
that record, you could be hitting the upper limit per record.

If you have a field with a lot of data but it isn't searched or sorted on,
try turning it to a Memo field and see what happens. As always, make a good
backup first before doing something like changing a field datatype.