Access Data Labels set to visible are not showing on my PC. Others people using the same database see the Labels

I created an Access database and for a group of my reports (all created in the same format) there is a row of vertical labels that is not appearing in any view of the reports for me only (It is showing the labels on other people's machines).  Keep in mind that this is the same PC that the database was created on and this was not a problem until yesterday.  When opening it yesterday I was in a GoToAssist and showing my desktop.  Only upgrade since the prior view of this report was an upgrade from Internet Explorer 6 to 7.  When looking at the labels in design view I can see there is a caption set, it is set with a white background and navy blue text and the label is set to visible.  Printing the report from my PC still results in blank labels.  I have tried several different printers, re-typing the text (which does not appear as well), rebooting, and detect and repair on Office.  
LVL 1
alcoahdAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Have you tried a Compact and Repair on the database?
0
alcoahdAuthor Commented:
This has been performed, but it has not corrected the problem.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Then the next step would be to Decompile the database and see if that solves it:

Build a shortcut and set the Target property to this:

"full path to msaccess.exe" "full path to your database" /decompile

After this runs, then immediately do a Compact/Repair again, then Compile the application - from the VB Edit window, click Debug - Compile ...

Even if this works, you might consider importing all your objects to a new, blank database.

Also: Are you running any code on the Open event of reports?

Have you tried adding a NEW label to see if that one shows up?

Finally, you might need to do a full re-install of Access/Office if you can't fix this.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

alcoahdAuthor Commented:
Tried the above but the problem remains.  

There is no code that runs on the opening of the report.

I created a new label and it shows up fine, except when I set the label to have vertical text, the text disappears.  This is how the other labels are also formatted, I took the vertical setting off of one of the vertical labels and the text returned.  It has something to do with the vertical text only.

Any new suggestions based on this?  
0
alcoahdAuthor Commented:
I changed the font from Arial to Arial Baltic and it has resolved the issue.
0
Jeffrey CoachmanMIS LiasonCommented:
alcoahd,

Just curious...
Did it work in Arial, when you first created it?

JeffCoachman
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Do you mean that a label set to Vertical with Arial font doesn't show? That makes no sense; Arial is a standard font and should work with anything.

It could be that the Arial font is corrupted. Can you use Arial in other programs (like Word)? If this were my machine, I'd find out about this, sounds like impending disaster.
0
alcoahdAuthor Commented:
The font did work initially as Arial.  I did some more research on the problem once I realized it was only vertical text that had the problem and found that it is a known issue with no resolution:
http://support.microsoft.com/default.aspx?scid=kb;[LN];KB839779

In fact looking at some other forum posts of others with a similar problem, it seems to start when IE7 is installed, which is exactly when it started for me.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.