Apostrophe Foot Sign?

[Guest]

I have a text box (default settings) on a form and am simply posting the text
box to a table (memo) via an append query. The problem that I'm having is
that users want to use the apostrophe (') for the FOOT sign and it won't post
to the table.

For example, posting the following:

The measurement is 9', 36".

Results in the following in the table:

The measurement is 9 , 36".

Any other character posts to the memo field in the table, but the apostrophe
will not.

Is this a reserved character of some sort that Access won't allow you to use?

Any help is greatly appreciated, thanks.

Gary

 

[Guest]

I believe you have to double them up, try converting every ' to ''. Use the
Replace function e.g. strText = Replace(strText,"'","''")
In the above function, the 2nd paramneter is an apostrophe inside double
quotes, the 3rd parameter is two apostrophes inside double quotes.

- Dorian