Problem with Rich Text Saves

  • Thread starter Thread starter Neil
  • Start date Start date
N

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
 
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!
 
Back
Top