Form to update table will not update one record

[Guest]

I have a table with many records (salespersons). The database user updates a
"Comments" field for individual records within the table via a form. I did
this so the user cannot see the table and alter or delete records within the
source table. When the user enters a comment in the form, the comment is
saved in the table.

There is one salesperson, John Doe, who for some reason when a comment is
added for him, it does not save in the table. It only happens for this one
person and his information was put into the table along with all the others
at the same time. Why would this one record not save the comments?

Any help would be appreciated! Thanks!

 

[Bill Mosca, MS Access MVP]

Is the Comment field a memo data type? They have been known to corrupt.

And then there is another gotcha with memos. They can store carriage
returns. I opened a table, went to a record that I KNEW had a memo in it and
it looked empty. I pressed Shift+F2 to open the zoom box and lo and behold!
There were about 20 blank lines in the beginning of the field. The data
showed up way down at the bottom.

 

[Guest]

Thanks for your response but no, it is not a memo data type. It's text. I
tried zoom as well just in case but there is nothing in the field.

This is so weird to me because it only happens to this one particular person.

Any other suggestions?

 

[Bill Mosca, MS Access MVP]

Not having the database to beat to death, I don't know...Have you tried to
manually create a new record for John or enter the data directly into the
table? Corrupt index o rrecord comes to my mind.

 

[Guest]

I understand.... I've tried a new record, recreating the table, etc. I have
no idea why it doesn't like this one person.

I appreciate your help. Thanks for trying! Have a great day.

 

[Bill Mosca, MS Access MVP]

You're welcome. I wish I had a difinative answer for you. Maybe the new
record will fix it.