L
Les Juby
A client needs a routine to alert him as to which memo records in an
Access-2000 database have had double apostrophes inserted in the text.
These are stopping a Java mouseover from executing.
Normally, while cycling through the recordset, I would use the InStr
function to test for a positive result indicating and embedded text.
ie. If InStr(rstemp("Keywords"),"searched") > 0 Then
would give a true for all <keywords> fields that contained the text
< searched >
But what do you do if you're looking for a double apostrophe itself.?
To specify the string you are searching for you can't use a single
apostrophe to deliniate the string, such as ' " ' and of course
using " " " won't work either.
Is there a character expression maybe that one could use instead.?
Or can someone perhaps suggest shattering my paradigm by using
something other than an If test on a function. Or maybe a different
function.?
thanks ( in anticipation )
. les .
Access-2000 database have had double apostrophes inserted in the text.
These are stopping a Java mouseover from executing.
Normally, while cycling through the recordset, I would use the InStr
function to test for a positive result indicating and embedded text.
ie. If InStr(rstemp("Keywords"),"searched") > 0 Then
would give a true for all <keywords> fields that contained the text
< searched >
But what do you do if you're looking for a double apostrophe itself.?
To specify the string you are searching for you can't use a single
apostrophe to deliniate the string, such as ' " ' and of course
using " " " won't work either.
Is there a character expression maybe that one could use instead.?
Or can someone perhaps suggest shattering my paradigm by using
something other than an If test on a function. Or maybe a different
function.?
thanks ( in anticipation )
. les .