Removing apostrophes

[Guest]

Is there an easy way to remove an apostrophe from a text field or do you have
to loop finding instrings several times and removing it before using in an
insert statement?
(e-mail address removed)

 

[Duane Hookom]

Consider the Replace() function. This might depend on your version of Acces.

 

[Marshall Barton]

Is there an easy way to remove an apostrophe from a text field or do you have
to loop finding instrings several times and removing it before using in an
insert statement?

A2K introduced the Replace function. You can use it in an
Update query to do what you want:

Replace(thefield, "'", "")