Access 2002

[Makita]

have a combo box and it is populated by table data. Some of the data
has (') comma's so when I select these items I get an error. The error
is a run-time error '3077': Syntax error (missing operator) in
expression. How can I fix the error?

[MGFoster]

Makita wrote:

have a combo box and it is populated by table data. Some of the data
has (') comma's so when I select these items I get an error. The error
is a run-time error '3077': Syntax error (missing operator) in
expression. How can I fix the error?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

If you're using the data in a WHERE clause you'll have to double the
single-quote. If using Access 2000, or greater, use the Replace()
function. E.g.:

WHERE this_string = Replace(that_string,"'", "''")
MGFoster:::mgf
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP84yToechKqOuFEgEQJ3bQCeP6XzU3YesqDcKac5e4x6+G n9YY8AoKYx
BDvPw/0chlT2eynfAuDQZ9+z
=r2jH
-----END PGP SIGNATURE-----