467,120 Members | 1,246 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,120 developers. It's quick & easy.

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
Nov 13 '05 #1
  • viewed: 2629
Share:
1 Reply
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" <De*****@hotmail.com> wrote in message
news:b5**************************@posting.google.c om...
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Julia Baresch | last post: by
6 posts views Thread by Peter Frost | last post: by
2 posts views Thread by Andrew Stanton | last post: by
2 posts views Thread by monnomiznogoud@yahoo.com.ar | last post: by
52 posts views Thread by Neil | last post: by
3 posts views Thread by rhobson2@triad.rr.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.