I solved weird query thing BUT...

[Bill Mitchell]

I don't know why it works.

When I try to use the value in a control on my form
(based on a numerical field) in the Field Row of my Query
Grid, Access sees only weird Chinese Letters.

However, if I use the Formal syntax, it works:

In other words:

Forms![Main]![ContactID] gives me Chinese Letters.

Format(Forms![Main]![ContactID]) gives me the correct
value of the field.

WEEEEIRD. Anyone know why this is? It's only like this
on numerical fields.

 

[Dirk Goldgar]

I don't know why it works.

When I try to use the value in a control on my form
(based on a numerical field) in the Field Row of my Query
Grid, Access sees only weird Chinese Letters.

However, if I use the Formal syntax, it works:

In other words:

Forms![Main]![ContactID] gives me Chinese Letters.

Format(Forms![Main]![ContactID]) gives me the correct
value of the field.

WEEEEIRD. Anyone know why this is? It's only like this
on numerical fields.

Post the query, Bill. It sounds to me like Access is trying to
interpret a number value as if it were a string, for some reason --
applying the Format function will force the value to be converted to a
string, and thus eliminate the confusion. But I haven't yet been able
to reproduce the problem. What version and SP-level of Access and Jet
are you using?