S
Salman Jariri
We are using an append query to add data from a form to a table (Access
2003). The table field is set to memo datatype, and the query reads its
parameter from the open form. The problem is that data will be
truncated in the table if more than 511 characters are entered at the
form.
We have already reviewed the support article "ACC2000: Query Expression
Truncated at 511 Characters". But we are having this problem in Access
2003. (Also we can not re-write the whole process and query in VB
becasue many other operations in the form are also done in this way)
Any help is highly appreciated.
Regards,
-Salman
2003). The table field is set to memo datatype, and the query reads its
parameter from the open form. The problem is that data will be
truncated in the table if more than 511 characters are entered at the
form.
We have already reviewed the support article "ACC2000: Query Expression
Truncated at 511 Characters". But we are having this problem in Access
2003. (Also we can not re-write the whole process and query in VB
becasue many other operations in the form are also done in this way)
Any help is highly appreciated.
Regards,
-Salman