MS Access Question

Factual Questions
1

I’ve built a cool database. My queries work well, my reports look professional, my macros perform as ordered. The switchboard has a spiffy graphic of a leopard.

However…today I was doing a little prettying-up. Making all fonts uniforms, etc. Now one of the reports has data from one column of one table showing up as symbols. Boxes and Asian-looking characters, mostly. The table is correct and in English and so is the query on which the report is based. The Properties list the font as Ariel. How can I get the report to display this text in English?

Thanks,

StG

2

Delete the report and re-import it from one of your backups. You are backing up your work, right?

OK, if not. Delete the text box in design view, then add it back again.

If that doesn’t fix it, then it must be a property of the underlying field in the query or table.

3

Does this problem persist if you run the database on a different computer?

If not then you may have some weird font problem on your development PC.

4

I actually ended up deleting the criteria (which I hadn’t changed before the wackiness ensued). Without the criteria, the data looked fine. Then I retyped the criteria and everything was jake. No clue why this happened, but I’m glad it fixed itself.

Thanks for the help.

StG

5

I’m not sure if this would apply to your situation, but when I got funky characters in the past, either changing the report’s printer or reinstalling the printer driver usually did the trick. Even after using Access for over 15 years, though, your is a new one to me.