Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Microsoft: Access Other topics FAQ

Access 101

More than 255 characters of text in a field? by simmerdown
Posted: 11 Jul 01

Access fields with the data type set to Text are limited to 255 characters [or the number specified in Field Size, whichever is smaller]. Try to insert longer strings into a text field, and you'll either get an error message or have the data cut off at the 255-character point.

There is an easy [and easily-overlooked] way around this limitation, though: set your field's data type to Memo. Memo fields are much more generous, allowing you up to 65,535 alphanumeric characters.

Also, according to Access Help, "If the Memo field is manipulated through DAO and only text and numbers [not binary data] will be stored in it, then the size of the Memo field is limited by the size of the database." Simply, with ingenuity you can exceed the 65,535-character limit as well.

For any alphanumeric data that might exceed 255 characters in length, don't employ the Text field type. Go with Memo.

Back to Microsoft: Access Other topics FAQ Index
Back to Microsoft: Access Other topics Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close