Getting mess "record is too large" when I enter data in access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I tried to enter data in a comment field, I get the mess "record is too
large'
message?
 
A text datatype field can hold only 255 character. If you have more then you
need to change it to a memo field. A memo field has it's limitations as you
can not sort on it but need to sort by the left-most 255 characters.
 
Is the comment field a text field or a memo field? If it's a text field, how
big is it, and how much text are you trying to put into it?
 
When I tried to enter data in a comment field, I get the mess "record is too
large'
message?
Click to expand...

There is a limit of 2000 bytes *ACTUALLY USED* in any record in a
table. For example, you can easily create a table with ten 255-byte
Text fields - and enter thousands of records into it - but you'll get
this message when you first actually *use* all ten fields to their
individual capacity.

Memo fields only count 16 bytes (IIRC) toward this total, so perhaps
changing your comment field from Text to Memo would help. It may be of
more help to reexamine how well your table is normalized - how many
fields do you have, and how big are they?

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

What do I do when a message record is too large shows when adding. 2
"Record is too large" on append query attempt. Access 97 4
DELETE FROM a table WHERE... 1
property value error 2
A temp solution to "Record is too large" 2
Export large query from Access 3
Data entry creating duplicate rows in table 3
Linking Text File : Error : "Record Too Large" 1

Back
Top