View Full Version : Amount of characters a MS ACCESS field can hold

02-03-2005, 11:49 PM
I built a form for clients to submit messages to me. In my MS ACCESS db the max character length accepted for a field is 255. My question is how do I let a user type as much as they want before they submit the form to me? Am I not doing something right or what should I do to get around the 255 chars maximum?

Any help or suggestions on this would be great.

Thanks in advance.


02-04-2005, 12:06 AM
Use the "memo" data type? I have 5000 line of text in a few of the fields in mine. I think the 255 character limit only applies to the "text" data type.


02-04-2005, 12:30 AM
Hey - thank you for the quick reply. I appreciate it. You know, after I posted this message I figured the silly mistake I made. See what 15 hours of pushing keys does to ones brain?

Thanks for the reply.


02-04-2005, 05:07 AM
The TEXT data types

A TEXT data type is a data type that establishes a field that can store text, or a combination of text and numbers (alphanumeric), but whose numbers are not used for calculations. Examples are phone numbers or e-mail addresses. When you create your tables through the Access user interface, you have two basic text types: TEXT and MEMO. But when you use SQL statements such as CREATE TABLE or ALTER TABLE to create your tables, you have many other synonyms of the TEXT and MEMO types to choose from.

In general, text fields can be up to 255 characters, while memo fields can be up to 65,535 characters, but if the memo field does not contain any binary data, then its only limit is the maximum size of the database (approximately 2.14GB or 1,070,000,000 Unicode characters). In addition, unused portions of text fields are not reserved in memory.

source = http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acintsql.asp