TextBox Appended To Memo Field Difficulty

[acepayne]

Heelo there,

I have a text box on a form, along with a button that runs an Append query. The value of the text box is appended to a Memo Field in a table.

Upon entering a larger amount of text (could be more than 255 characters), the append query doesn't seem to work.

If I place a text box control on another form, and bind it to the Memo Field, I can enter loads of text (way over 255 characters), and it is fine. The table is updated as desired.

How can I get the first Append operation to work properly?? I need to be able to add the record, and it would be nice to not have to go back and edit this memo field afterwards.

Any suggestions?

Thanks,
Gord Ace Payne

 

[Pat Hartman]

Append queries add new rows to a table. Update queries change the values in specific columns. You want an update query.

 

[acepayne]

Thanks Pat,

I managed to get it done by doing it all programmatically. the .addnew and .update methods for the recordset allowed the big textbox contents to be added to the field in the new row.

In order to use the update query, I would have do an append query first, and then run the update query? I am definitely adding a new row. Seems kinda crazy to me!

Anyway, thanks again!!