>Can I specify in an SQL Insert statement that a value is to be placed in a memo field.
>
>Here's what I'm trying:
>
>xcomments = "anything that has special characters like (.,;'"!!{}[]-+=)."
>
>INSERT INTO feedback VALUE(xcomments)
>
>I get syntax errors or command errors becuase the is reading the contents of
>the string. I've tried macro substition, and it doesn't like the &. I've
>search my msdn library and now I'm at wits end.

When I tried to run your code above, I got an error on the first line. Care to repost with a string that actually works? :-)