Invaid Argument Error When Updating Access Memo Field

[Jeff Floyd]

This question was probably asked before but I could not find it. I have fields defined as memo in an Access 2000 database. I am using a form for data entry and then running an update query from a button to update the data table. The memo fields update correctly if there are fewer than 128 characters. If there are more than 128 characters, I get an "Invalid Argument" error and the data does not update.

I am not a VB programmer and would like to have a solution that only uses Access functions if possible.

[vksingh24]

I don't get any such error. Please post your code/query you are using

[Jeff Floyd]

I am using a simple update query initiated by a button click.

[missinglinq]

As vksingh24, we need to see your SQL code.

Welcome to Bytes!

LINQ ;0)>!