INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS
Come Join Us!
Are you a
Computer / IT professional?
Join Tek-Tips now!
- Talk With Other Members
- Be Notified Of Responses
To Your Posts
- Keyword Search
- One-Click Access To Your
- 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.
Promoting, selling, recruiting, coursework and thesis posting is forbidden.
More than 255 characters of text in a field?
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
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:
- Talk To Other Members
- Notification Of Responses To Questions
- Favorite Forums One Click Access
- Keyword Search Of All Posts, And More...
Register now while it's still free!
Already a member? Close this window and log in.
Join Us Close