Web Development

Ask something
Discussion Locked

Yet another Access question.

0 helpful
3 replies

by makita

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I 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?

3 replies

by dklippert

When Access sees an embeded quote mark, it assumes that it has come to the end of the string. Use a pair of double quote characters (") in place of the single quote characters.
See:
http://tinyurl.com/xj6v

This discussion is closed to new replies.