Chinese symbol in query

[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 or something similar and
appears they way it should on the form but when they query pulls it from the
form it looks chinese. The expr in the query looks like this -
form![myform].[mytextbox]. This is happening for all records on the form
not just one.

I am only having this problem when selecting this through a text box
on a form with a query. When I do a select statement right from the table I
get the
appropriate number value. So it is something having to do with the text box
or form. All the font settings for the text box are right (If they weren't I
would see chinese on the form, but I've double checked anyway.

This has me baffled!
Any Ideas?

TIA,
TimJ

 

[peregenem]

The value in the field looked like chinese characters.

<a little OT>
Have you called in a SQL consultant recently? :

http://groups.google.com/group/microsoft.public.sqlserver.programming/msg/2e32605d66c94b73

"When I stress test a schema and they have an
NVARCHAR(255) [Unicode text] column for something
like a phone number, I load it with
a Buddhist sutra in Chinese."

Note that Text columns in later versions of Jet are Unicode. And I
wager no one out there is using a CHECK constraint to test for
ASNI-only characters
</a little OT>