How to Find & Replace the # Symbol

L

lbohen

Using MS Access 2003 SP3 I am unable to [Find & Replace] the # symbol.

How do I do this?
 
K

Ken Snell \(MVP\)

Try [#] instead of #.

# is a wildcard character in ACCESS/Jet, so you must escape it for the
database to "see" it as its actual character.
 
Top