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

Jim Dettman jimdettman at earthlink.net
Mon Oct 4 08:01:48 CDT 2004


Steve,

  First thing I check is the regional settings in Windows.  If all look OK, change one of them, then change it back.  There was an old Windows bug related to this.  Might still be in XP.

Jim Dettman
(315) 699-3443
jimdettman at earthlink.net 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Steven W.
Erbach
Sent: Sunday, October 03, 2004 3:55 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] A2K: Report number format visible but not numbers


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


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list