That did it... Simply replaced (pardon the pun) the string variable name in
the filter command with the Replace() function to change all single apo's to
double apo's. :)

Thanks!

J

-----Original Message-----
From: Pardee, Roy E [mailto:roy.e.pardee@l...] 
Sent: Tuesday, October 16, 2001 9:06 AM
To: professional vb
Subject: [pro_vb] RE: Filter w/ apostrophe


I believe you can escape one apostrophe with an extra one--try using the
Replace() function to search your filter string for ocurrences of single
apostrophes & replace them w/doubles.

HTH,

-Roy

Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
(xxx) xxx-xxxx

-----Original Message-----
From: John Walborn [mailto:JWalborn@m...]
Sent: Tuesday, October 16, 2001 7:46 AM
To: professional vb
Subject: [pro_vb] Filter w/ apostrophe


All,

I know this has been discussed before, but I cannot remember the answer...
Is there a way to filter an ADO recordset client-side by a value that may or
may not contain an apostrophe?