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]
