Brian,
I can't believe it is that easy. I feel both exhilerated and stupid both at the same time.
Can it be used for more than one item? This is how I am using it so far:
UDATE [Tab] SET
x = " & replace(x.value,"'","''")
WHERE ...
the on load I am using the same reverse scenario
x.value = replace(rs![x],"''","'")Do you just run through it twice to replace both ' and & like this:
x.value = replace(replace(rs![x],"''","'"),"&&","&")
or can you send it some fabulous and exciting arguments? Sorry, there is no examples in my MS help.
Regarsd,
-Roni
Roni Estein
Roni.Estein@e-drugscanada.com
https://www.e-drugsCanada.com