why do I get a # in memo field?

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

Guest

I currently have a form that contains a memo field. This field is used to
record notes and the user is allow to add and delete the notes.
Occassionally when a note is added and later the user comes back and adds
another note, Access will populate the note with ######. I can not figure
out why this happens. Any suggestions?
 
I currently have a form that contains a memo field. This field is used to
record notes and the user is allow to add and delete the notes.
Occassionally when a note is added and later the user comes back and adds
another note, Access will populate the note with ######. I can not figure
out why this happens. Any suggestions?
Click to expand...

Sounds like the memo field has become corrupted. If you don't have a
backup, MAKE ONE NOW - this problem can spread and damage your
database permanently!

Check out the corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm or the suggestions at
http://allenbrowne.com/ser-47.html.


John W. Vinson[MVP]
 
Back
Top