Large text fields in Access

Guest · Jan 17, 2005

How do I create text fields with greater than 255 characters in Access?

Ken Snell [MVP] · Jan 17, 2005

Create a memo field in the table. That will hold thousands of characters.

Larry Daugherty · Jan 17, 2005

Hi Jessie,

In your table design, change the type to Memo

HTH

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database	0	Mar 30, 2021
Expanding text greater 255 field size	1	Oct 31, 2005
import excel .csv into access (cells +255 chrs)	3	Nov 18, 2008
Importing Text File : Error "Field too Large"	4	Jul 10, 2006
Exporting files from Access into Excel	1	Mar 30, 2010
Running Query on memo field - character limit	4	Jul 31, 2009
Memo Field to Text Field Conversion	2	Mar 30, 2005
Entering text in a table field	2	Nov 8, 2007

Ask a Question