J
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
*****************************************
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
*****************************************