Appending a memo field - invalid argument

[acepayne]

Hi there,

I have a form with a bunch of text boxes, etc. that eventually runs an append query to add the record to a table.

One of the text boxes' contents is to be added as a memo field in the table.

When I enter in a large amount of text (more than 255 characters), I recieve an "Invalid argument" error, and the record is not appended.

I can, however, add a record, and then edit it in another form (make it larger than 255 characters), where it is saved just fine upon clsing the form

I would like to be able to add the record on the first go. Is it possible?

Please let me know of any suggestions.

Thanks,
Ace

 

[Rich]

Why append it, just bind the field to the table.

 

[acepayne]

Hey Rich,

Binding it works fine. Thanks for the help.

I'd still like to know why you are unable to append the large number of characters to the memo field, though.

Anyway, problem solved. I appreciate that.

Cheers,
Ace