This is how the form calls the query.
Private Sub Command55_Click()
On Error GoTo Err_Command55_Click
Dim stDocName As String
stDocName = "insertitem"
DoCmd.OpenQuery stDocName, acNormal, acEdit
Exit_Command55_Click:
DoCmd.Close
Exit Sub...
The query worked that way. :) So it appears to be in the Forms call to the query? I checked the textbox there is nothing set to stop at 100 charaters that I can find.
You got me closer, but I still can't think of what the problem is.
I'm using an append query to add a new record from a form.
The form has a text box and the contents get entered into a Memo field in the database. When I put more than 100 chars in the textbox and try to save to the database I get an "Invalid Argument" error.
If I use less than 100 chars then...