Find on a field that contains quote

[Nihon Marcel]

Hi,
The following statement
rs.Find "Design" & "='" & Me.Design & "'"
runs without probem only if value contain one or many quotes.
Help would be appreciated.

Regards

 

[RobFMS]

Replace the double quote with a single quote.
Use the Replace() function.

HTH

--

Rob

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Problems with your database? Need to upgrade your application?
Contact the FMS Professional Solutions Group: www.fmsinc.com/consulting

Need a Book Recommendation?
www.fmsinc.com/toplevel/books.htm

Need software tools for Access, VB or .NET?
http://www.fmsinc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-