Filter property

[yancy]

I need to filter an ADO recordset by the name of a company that contains more than one apostrophe in their name. Even though I replace the single apostrophes with double apostrophes my code errors out. Help.

[d.paulson]

Can you post the statement that your using?

David Paulson

[RobZeilinga]

Hi there ,
I don't kmow if this will help, but I started using the accent ` chr(96) instead of the single quote '
Visually it looks the same and I use the Replace() func to screen incoming records to convert B4 saving to the DB.

Thanks RobZ