Problem with Rich Text Saves

[Neil]

I am using a rich text control in Access 2000, and have run across this
problem:
a) enter text in the control;
b) select Save Record from the Records menu (or click a button to run
docmd.accmdsaverecord in code);
c) click back in the control and type a character;
d) the message "The data has been changed" appears when a character is
typed, and that character is removed;
e) after the message and the removal of the new character, the control works
fine.

I tried using Stephen Lebans' rich text control, and the phenomenon is the
same, with the following differences:
a) the new character being typed (step c, above) doesn't appear at all
b) a second message box appears after the first one, stating, "Property is
read-only," with RTF2 in the title bar.

So this seems to be a flaw with the class itself. Anyone have any idea how
to work around this or otherwise avoid this troublesome message when working
with rich text boxes?

Thanks!

Neil

 

[Neil]

Just wanted to follow up on this, in case someone reads this post 100 years
from now and has the same problems (now THERE'S a lot of faith in Microsoft
products...). So the problem was: type something in rich text control; save
record; type something else; get message "data has changed."

Problem was that I was using SQL Server 7 and didn't have a timestamp field
in the table (duh!...). So adding the timestamp field resolved the problem.

And, if anyone's reading this in the year 2107: Greetings from 2007!