Text Field - Max Number of Characters

  • Thread starter Thread starter The Boondock Saint
  • Start date Start date
T

The Boondock Saint

Is there a point in a Text Field in Access when it wont accept any more
text.... like a field size?
 
The said:
Is there a point in a Text Field in Access when it wont accept any
more text.... like a field size?
Click to expand...

Yep. When you create a table every Text field has a field size property that
you enter to set the maximum number of characters allowed. This defaults to 50
(I think) and the maximum number allowed for you to enter in this property is
255. When you need more than 255 characters you should change the Data Type to
Memo which has no fixed limit other than hitting the Access file size limit
(currently 2GB). Memo does have a few limitations though compared to Text in
that you can't index or group on it.
 
You must log in or register to reply here.

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

Similar Threads

MS ACCESS 2013 Long Text filed filter by another tables Long text field 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
limited txt box 6
Memo Field in Table Truncated in query results and in report 1
Change the color of each capital letter in a rich text memo field. 0
Counting specific characters within a field 5
Field size change 10
Text Box / Table field charaters 6

Back
Top