Hi Richard
In the UK we often use the " symbol to mean inches. so a 2 inch pipe can be named 2" pipe for example.

When using your code reproduced below , Access returns an error when looking for something that has " as part of its name.

Is there any way around this please ?

DoCmd.OpenForm "CustomerF", , , "CompanyName LIKE ""*" & CompanyNameSearch & "*"""

Vince

---

Reply from Alex Hedley:

You'd need to run a string find then a string replace first looking for " in CompanyNameSearch or whatever your search term is.
Either use ' to delimit the string or use two consecutive doublequotes to represent a single doublequote:
LIKE '"'
LIKE """"