Text Box limitations in Access

  • Thread starter Thread starter MCM
  • Start date Start date
M

MCM

When entering data into a text box on a form, entry is limited to much less
than 255 characters. Why would that be, and how can I make an adjustment?

There are other text boxes in this form which hold much more than 255
characters. I don't seem to see where to fix this.

Any assistance would be very welcome!

Margaret
 
If the textbox is bound to a field in a table (perhaps via a query), it will
be limited to the size of that field in the table. 255 is the maximum for a
text field; Access's default is smaller (20 or 50 from memory), and the
table designer can set any size that is appropriate (eg. for a postcode here
in Australia, 4 would be appropriate). A textbox control itself is
(essentially) unlimited in the number of characters it can display - they
are also used for memo fields.

HTH,

Rob
 
Back
Top