Need help with text box vs memo field.

[FatMan]

Hi all:
I have a form that is not bound to any table, which has a text box on it.
The text box is so the user can enter some notes on the form and have them
recorded. The form updates a table via an append query and the text box is
appended to a memo field. It appeared to be working fine but on my last test
I am getting the error message "Invalid Argument" when the query is ran.

In this text the text box contains 166 characters. Is there a max number of
characters allowed in a text box? I had entered some hard returns in the
test text but delete them to see if this would make a difference but it
didn't.

Any help is greatly appreciated.

Thanks,
FatMan

 

[Marshall Barton]

I have a form that is not bound to any table, which has a text box on it.
The text box is so the user can enter some notes on the form and have them
recorded. The form updates a table via an append query and the text box is
appended to a memo field. It appeared to be working fine but on my last test
I am getting the error message "Invalid Argument" when the query is ran.

In this text the text box contains 166 characters. Is there a max number of
characters allowed in a text box? I had entered some hard returns in the
test text but delete them to see if this would make a difference but it
didn't.

There's probably some quotes/apostrophes in the notes that
are messing up the syntax in your append query. If so, then
you need to use the Replace function to double up whichever
one you are using around the notes value.

 

[Tom van Stiphout]

On Wed, 8 Apr 2009 05:38:01 -0700, FatMan

If there is a limit it is certainly WAY higher than 166. You probably
had some special characters in the text, such as <single-quote> which
can mess up your VB script if you're not careful, because ' is also a
string terminator. If that's your problem, double-up on those
single-quotes using the Replace function.

-Tom.
Microsoft Access MVP

 

[FatMan]

Marshall:
Thanks for the post. Could using the "@" sign cuase the problem?

Thanks,
FatMan

 

[Marshall Barton]

Not that I ever heard of

Have you checked the problem notes for the quotes?

 

[John W. Vinson]

The form updates a table via an append query and the text box is
appended to a memo field. It appeared to be working fine but on my last test
I am getting the error message "Invalid Argument" when the query is ran.

Please post your code and the SQL of the append query.