Text Box limitations in Access

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
 
R

Rob Parker

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
 

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

Top