String Express in Append Query

[Joel]

In access 2000 - I have a text box in a form that gets
populated when the form opens with a string expression
that includes currency, dates, and text (ex. "...AS of
5/4/2003 the balance on this account is $576.98".) The
entire string is approximately 370 characters. I am
trying to run an append query when the user pushes a
button on this form that appends to a memo field in a
table. The append query references this text box as
followsDataAppend: Cstr(forms![MyForm]![MyTextField])
and tries to append to the memo field. However, what gets
appended is just some garbage (mixture of symbols - mostly
boxes). Any idea what causes this? Is there a maximum
number of characters you can append in the append query or
is it caused by the text field getting populated by a
mixture of data types?

Thanks in advance for any advice on this.

 

[Van T. Dinh]

1. Post the relevant Table Detail and the SQL String of
your Query.

2. I don't think the fn CStr() in necessary here.

HTH
Van T. Dinh
MVP (Access)