query getting value from form looks like chinese!

G

Guest

I have an insert query pulling a value from a text box on the form. Recently
the query stopped working and so I opened the query in datasheet view. The
value in the field looked like chinese characters. The value on the form is
a number w/field size of double and = 1265.14 . This is happening for all
records on the form. After copying the chinese letters and pasteSpecial as
bitmat in excel, they appeared to be an Icon.

I am only having this problem when looking at this field through a text box
on a form. When I do a select statement right from the table I get the
appropriate number value.

Any Ideas?

TIA,
TimJ
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chinese symbol in query 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Check box and make table query 1
Query returns weird symbol instead of actual value! 1
result query on a form 1
Union query is displaying Chinese characters for one of the fields 4
Query driven by form field 1
showing just the latest value in a text box 3

Top