Truncation in MS Access 2003

G

Guest

Does MS Access 2003 truncate text data fields at 255 characters? How do I
change the truncation of text data?
 
J

John Vinson

Does MS Access 2003 truncate text data fields at 255 characters? How do I
change the truncation of text data?
Click to expand...

Text fields are limited to 255. Memo fields are limited to 65536
characters, or actually to 2 GByte if you fill them programmatically
rather than by typing into them.

John W. Vinson[MVP]
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Memo field 1
appending more than 255 characters into a Memo field 13
Make Table Query Truncating Memo Field at 255 Characters 2
Mail Merge with Excel and Word 2007 1
FIeld with more than 255 char on report 0
EXPORT QUery with memo field to excel, truncated data 2
Truncated entries 8

Top