Inserting "Invalid Characters" into an Access database

[WozFromOz]

I am wishing to input pure text from a form into an Access 97 Database using Insert Record. The challenge is the so called "invalid characters" and how to successfully input them.

The main protagonists seem to be Single Quote (') and Commer (,). I am dealing with Single Quotes by replacing them with two Single Quotes thus

strInfo = Replace (strInfo, "'", "''")

however the Commer has me stumped as it tricks the SQL into thinking there are more values than fields even if surrounded by Single Quotes.

How do I deal with the Commer and what other Invalid Characters do I need to look out for?

Thanks
WozFromOz

 

[Jonax]

You could replace it with it's ascii equivalent...?