Weird Characters return on query

[bstice]

I have a query and one of the fields pulls the value from a text box in a form. I think do calculations in the query based on that value. The Calculations work correctly, but the value in the query field (pulled from the text box) is displayed this way:

㌲냞䅑

Another with the same is displayed this way:

蔜ᇫ鐗䄺

Both should be general numbers.

Any help is appreciated and if I can rewarded! Thanks

B

 

[Guus2005]

Look at the properties of the textbox. Specifically the FontName. Does it show some readable font like MS Sans Serif?

Is the textbox used to paste emails in? Newline characters are not interpreted correctly most of the time.


HTH

 

[bstice]

Currently the font reads as Tahoma. I use a DSUM function to populate the textbox. Thanks

 

[boblarson]

Then there is a good chance you are suffering corruption, either at the table level or the form. I would try importing everything into a new, blank mdb or accdb file and see what happens.

 

[bstice]

No love for me today. Thank you both for our recommendations. I tried the new DB suggestion and checking the font. Both result in the same error. I'll continue to play with it. Thanks!

B

 

[Guus2005]

Could you post a sample database?