Invalid Argument when more than 127 characters

[John d via AccessMonster.com]

When I run an append query based on a form (memo field) if I type more than 128 characters I get an Invalid Argument message, however less than 128 it works just fine. Anyone know what I can do? I know that the memo field holds up to 65K+ characters and if I paste the text straight into the table, it works, but the query will not. Here is my SQL statement:

INSERT INTO Commentstbl ( Comments, [Date entered], [Student ID], [Inputers Name] )
SELECT [Forms]![Commentfrm]![Comments] AS Expr1, [Forms]![Commentfrm]![Date entered] AS Expr2, [Forms]![Commentfrm]![Student ID] AS Expr3, [Forms]![Commentfrm]![Name] AS Expr4


Thanks for anyone who can help me with this nightmare.

*****************************************
* This message was posted via http://www.accessmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.accessmonster.com/Uwe/Abuse.aspx?aid=ed0109aefad34990b20749ce4db04c7e
*****************************************

 

[John Spencer (MVP)]

I might try declaring the parameters

PARAMETERS [Forms]![Commentfrm]![Comments] LongText,