• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 229
  • Last Modified:

Access 2010 Database with a form with a Memo field - updates to memo field produce an error.

Access 2010 Database
Form has a memo field being used for notes.  This has worked for several years.  Now we are receiving an error which states:

"The field is too small to accept the amount of data you attempted to add.  

1. How do I resolve this error?
2. is there a way to give move than 255 characters?
0
btgtech
Asked:
btgtech
  • 3
  • 3
  • 2
2 Solutions
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
A Memo Data Type field will hold approx 65K characters.
A Text Data Type is 255 max

mx
0
 
btgtechAuthor Commented:
So 65k is enough characters.  So I do not believe that any of the records are reaching this limit.

Any ideas on why we would be receiving the error?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Well, if you are positive it's a Memo field ... then not sure ?
Can you upload the db, removing any sensitive data ?
What is the exact error number?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
btgtechAuthor Commented:
There is no error number.

I have tried to compact and repair the database.

I am going to take all of the data into a word document and confirm that the formatting is not causing the issue.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I have tried to compact and repair the database.
Were you able to compact and repair? If so, then I assume that did not resolve your issue?

What are you doing when you get the error? Are you entering data from the keyboard, for example, or are you copy/pasting data into the field, or using VBA?
0
 
btgtechAuthor Commented:
The error is received when data is entered into the field from the keyboard or pasted in from other sources.

The error is displayed when the user goes to close out the form.

We can add data to the memo field in the table directly without error.

Jennifer
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Is there possible a Validation Rule on the Text Box for this Memo Field on the Form ?
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
In addition to Joe's advice, check the properties of that control to insure you haven't altered any. A quick way to determine this is to place a new Textbox on the form, and bind that Textbox to your Memo field (i.e. set the ControlSource). If you can interact with that new Textbox, then you may have an issue with the original one.

It's also possible that you have Form-level corruption, which often cannot be repaired by a Compact/Repair. If that's the case, then you would need to recreate the Form from a recent backup.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now