Invalid Argument Error Based off Append Query

[gekko97]

Hello,

I had a question concerning an Append Query.

I am currently working in Access 2002, and created an Append Query that
pulls its data directly of off a form the user completes. When a user
using Access 2000 uses the same form they receive the "Invalid
Argument" message. I have not downloaded the update recommended by MS
to this point as I was hoping for a simpler solution. Upon review the
Append Query Field in Access 2002 houses all the characters entered by
the user up to 255 maximum. However in the Access 2000 Apppend Query
design this field is cut off. Is there a limitation to the number of
characters the query field can store in Access 2000? Also the field
that is causing the error is a DLookUp field from a table that's data
type is set to text with the 255 character total. The Append Query
will work, however it will display the error message if there are more
than 175 characters in the in the text box. Please let me know if I
can provide any more info, as this has confused me, and I may be
missing a piece of information that is needed. Thanks for any
assistance provided.

 

[[MVP] S.Clark]

Query fields do not "store" data. They really only display the data that is
stored in the table(s), of which the query is based.

Post your SQL.