MS Access 2002 - query form control returns funny symbols like [][]

MS Access 2002 - query form control returns funny symbols like [][]

I am running an append query on a form. Access is having trouble with
the calculated fields and comboboxes. Example – referring to
forms!FormName!ControlName within the query should return the value of
that control, correct?

I am receiving symbols such as boxes [] or [][] as well as Chinese
symbols. Any thoughts as to why this is happening. thanks

This happens if Access does not understand the data type of the calculated
controls.

Typecast the calculated fields, and set the Format of unbound controls.

For more detail, see:
Calculated fields misinterpreted
at:
http://members.iinet.net.au/~allenbrowne/ser-45.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dman" <Derekst@hotmail.com> wrote in message
news:b5358ccf.0411011951.51ec395e@posting.google.c om...[color=blue]
> MS Access 2002 - query form control returns funny symbols like [][]
>
> I am running an append query on a form. Access is having trouble with
> the calculated fields and comboboxes. Example – referring to
> forms!FormName!ControlName within the query should return the value of
> that control, correct?
>
> I am receiving symbols such as boxes [] or [][] as well as Chinese
> symbols. Any thoughts as to why this is happening. thanks[/color]