Symbols in the data (problem?)

[dccjr]

I have a textbox on a user form that is Inserted into a column on a table. The column is type-defined as "Memo". A coworker was entering data recently and recieved an Invalid Operator error. In his entry there were numerous symbols that he'd used (#, ', ", etc). Are these likely to cause a problem when saving to a table? Is there a way to work around them, short of not using them in the data at all? At times, this field will need to have a direct quote. Anyone else have a similar problem?

[June7]

The quote and apostrophe characters can produce issues with constructing SQL statements in VBA. Otherwise, typing symbols into bound controls should not be an issue. Would have to know more about what the user was doing when the error triggered.

[dccjr]

Thanks. I know that he had multiple sets od apostrophe (apostrophi?) and quotes in it and thought that it might be monkeying with the SQL Insert. As always, thanks so much for your help.