Printable View
Is it possible to find a record on an Access database when the name you are looking for contains an apostrophe? E.g. St Mary's Bakers. I am doing a search on Customer name and get a runtime error 3077 whenever there is an apostrophe.
I am using Findfirst with the name as a string.
All single quotes must be replaced with 2 single quotes (NOT a double quote) before submitting it for processing:
example: O'Brien must equal O''Brien for it to work
You can use VB6's REPLACE function to do this for you as well
Tom
[This message has been edited by Clunietp (edited 01-24-2000).]