[AccessD] A2K: Report number format visible but not numbers

Steven W. Erbach serbach at new.rr.com
Sun Oct 3 14:55:04 CDT 2004


Dear Group,

I helped a friend get MS Office 2000 up and running on his PC yesterday after his PC vendor re-formatted the drive (virus infestation) and re-installed Windows XP Home w/SP2. This system also has a canned Access application that installs Access 2000 Runtime. I installed that AFTER I'd upgraded Office 2000 to SP3. That took a bit of trial and error. Whenever the Runtime install asked about overwriting existing DLLs I told it NO.

Now when my friend runs the Access applications that he uses (his wife runs the Access Runtime app), his reports come out funny. That is, for all the text boxes that contain numerals (phone numbers, dates, currency, other numbers), the FORMATTING of the data (e.g., parentheses around negatives, dollar signs and decimals for currency, slashes for dates, hyphens and slashes for phone numbers) appear in the report preview, but there are NO NUMERALS! The dollar signs are at varying distances from the decimal points as if there are numbers there, but no numerals are visible.

The fields on the reports are all VISIBLE. As an experiment, I tried changing the background color to yellow and the text color to red for one of the text box objects in design mode. But when I preview the report, the format symbols are red but the background is still white, not yellow. I change the font weight to Bold and I see bold dollar signs and decimal points. I add a shadow border around the text box, but that doesn't show up in preview mode. I change the text alignment to Left, and all the dollar signs line up on the left...but still no numbers.

I've checked the query. All the numbers are there. Again, this is just for fields that have numerals in them. The names of the individuals are there in the report preview, just no numbers or dates or phone numbers (except for the formatting symbols).

What does this sound like to you?

Thanks,

Steve Erbach
Neenah, WI





More information about the AccessD mailing list