Append query from form input - Access 2000

[Aramesh]

I have a form that contains unbound text boxes (controls) which accept input
by the user. An append query runs off this form and appends the text box
values into a table as one new record. The form is refreshed to enter new
values for the next record.

The text box control that contains values appended to a memo field
(miscellaneous description) in the table does not work if the text in the box
is more than 100 characters in length. The append query works fine if the
text in the form is less than 100 characters. The query halts if the length
is longer.

The funny thing is that I dont face this issue in Access 2003, but the users
have only Access 2000

 

[Allen Browne]

First thing would be to ensure the users have applied the service packs for
Office 2000 and for JET 4. They can download them from:
http://support.microsoft.com/kb/276367
http://support.microsoft.com/kb/239114

If that doesn't solve the problem, see if these issues apply:
Truncation of Memo fields
at:
http://allenbrowne.com/ser-63.html

We don't know how you are running your query, but if you use RunSQL, you
might get more reliable results from Execute:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html

It's not clear why you are using unbound controls. Unless you have a special
reason not to, using a bound form might be the simplest solution.