Memo field error

[adacprogramming]

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 it appends fine. The error doesn't come from the textbox, I can put over 100 caracters in that, the error comes from the Append process.

In the append query I use this string.
Expr13: [forms]![additem].[description]

additem is the form
description is the textbox field.

Thanks for the help
Dwayne

 

[jaydwest]

try using

Expr13: [forms]![additem]![description]

Try Exclamation Point betweeen additem and description.


Good Luck.

 

[adacprogramming]

Nope, Still get the error.

 

[jaydwest]

Try running the query from the database window. When you are prompted to enter a value, type in something with about 30 chars, try it again with something more then 64 chars, and last with something more than 100 chars.

What happens?

 

[adacprogramming]

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.

 

[adacprogramming]

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

Err_Command55_Click:
    MsgBox Err.description
    Resume Exit_Command55_Click
    
End Sub

 

[supercharge]

I do not see "acNormal" in the list below which is from Access Help.

Try acViewNormal instead.

----------------
AcView can be one of these AcView constants.
acViewDesign
acViewNormal
acViewPivotChart
acViewPivotTable
acViewPreview

 

[adacprogramming]

Thanks for the try but I get the same error.
Not sure it matters but I'm useing Access 2000