Need help with text box vs memo field.

  • Thread starter Thread starter FatMan
  • Start date Start date
F

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
 
FatMan said:
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.
Click to expand...


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.
 
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
 
Marshall:
Thanks for the post. Could using the "@" sign cuase the problem?

Thanks,
FatMan
 
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.
Click to expand...

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