General discussion

Locked

Yet another Access question.

By Makita ·
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?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by DKlippert In reply to Yet another Access questi ...

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

Collapse -

by Makita In reply to
Collapse -

by Makita In reply to Yet another Access questi ...

This question was closed by the author

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums