text box characters appear as square box

  • Thread starter ielmrani via AccessMonster.com
  • Start date
I

ielmrani via AccessMonster.com

Hi,
I am using office 2003.

I have a form that's linked to a query. when I run the form, one of the text
boxes shows funny character (%!,<!䬃!). All the other text boxes are fine
except this one. When I run the query by itself it's fine. Does anyone have
the answer to this? I did some search in the web but in vain. Thanks in
advance.
 
D

Dirk Goldgar

ielmrani via AccessMonster.com said:
Hi,
I am using office 2003.

I have a form that's linked to a query. when I run the form, one of the
text
boxes shows funny character (%!,<!䬃!). All the other text boxes are fine
except this one. When I run the query by itself it's fine. Does anyone
have
the answer to this? I did some search in the web but in vain. Thanks in
advance.
Click to expand...


Check the Font setting for the text box.
 
D

Dirk Goldgar

(re-sending, as my original reply hasn't appeared)

ielmrani via AccessMonster.com said:
Hi,
I am using office 2003.

I have a form that's linked to a query. when I run the form, one of the
text
boxes shows funny character (%!,<!䬃!). All the other text boxes are fine
except this one. When I run the query by itself it's fine. Does anyone
have
the answer to this? I did some search in the web but in vain. Thanks in
advance.
Click to expand...


Check the Font setting for the text box.
 
I

ielmrani via AccessMonster.com

thanks for the reply.
I looked at the font settings and I did see anything unusual.

Dirk said:
(re-sending, as my original reply hasn't appeared)
Hi,
I am using office 2003.
Click to expand...
[quoted text clipped - 6 lines]
the answer to this? I did some search in the web but in vain. Thanks in
advance.
Click to expand...

Check the Font setting for the text box.
Click to expand...
 
D

Dirk Goldgar

ielmrani via AccessMonster.com said:
thanks for the reply.
I looked at the font settings and I did see anything unusual.
Click to expand...


Then I'm stumped. If the query is okay, and the form is bound to the query,
and the text box is bound to one of the fields returned by the query, but
the text box is garbled while the field in the query is not, then I can only
wonder if maybe the form is corrupted in some way. You could try (a)
deleting the text box from the form and re-adding it from the field list, or
(b) building a whole new form from the query.
 
I

ielmrani via AccessMonster.com

I did create a new text box and I got the same mess. I also compacted and
repaired the database. I created a new form and linked the same query to it
and the form is fine. So I think you're right the form is corruped. Thanks
 
Top