[Webinar] Streamline your web hosting managementRegister Today


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

Posted on 2008-02-12
Medium Priority
Last Modified: 2013-11-28
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.  
Question by:alcoahd
  • 4
  • 3
LVL 85
ID: 20875909
Have you tried a Compact and Repair on the database?

Author Comment

ID: 20875948
This has been performed, but it has not corrected the problem.
LVL 85
ID: 20876108
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.
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.


Author Comment

ID: 20877410
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?  

Author Comment

ID: 20877615
I changed the font from Arial to Arial Baltic and it has resolved the issue.
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 20881521

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

LVL 85
ID: 20883245
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.

Accepted Solution

alcoahd earned 0 total points
ID: 20883920
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:

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.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Get the source code for a fully functional Access application shell with several popular security features that Access VBA application developers desire, but find difficult or impossible to figure out how to code. You get the source code for managi…

612 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question