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?
btgtechAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
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 Architect / Systems AnalystCommented:
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
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

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 Architect / Systems AnalystCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.