Value refuses to update

[Amy Blankenship]

In my database, I'm replacing returns in records with tildes, because the
component I'm using to consume the access data returns the results of
queries like a tab-delimited file, so excess returns screw things up. Most
places, simply replacing the field value with a tilde BeforeUpdate and then
replacing the tilde with a return OnCurrent works. However, in one spot the
tildes stubbornly show up in the form, even though a debug.print of the
value shows the returns are in there and the tildes are not. I've tried
repaint, requery, and everything else I can think of, and the screen won't
update unless you navigate away from the record and come back.

Any thoughts?

TIA;

Amy