Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I replace a quote (') in a text field with a space ( )? I want to lookup the city, but my lookup file contains 'O Fallon' for the city O'Fallon. I tried to use replace([City],''',' ') but that did not work. Is there an escape character?
May be this
Replace(City, Chr(39), ' ')
You can also use:
PurgeChar (City,Chr (39))
Cheers
That worked. Thanks!