Why is Access substituting my fonts

I have some Access forms and now on some machines forms with the font Calibri is being substituted with a font called Time New Roman (detail).  The Calibri font is still on my machine and I don't know what has caused this, but it is a definite problem and  I need a resolution.
LVL 1
BradleyClevelandAsked:
Who is Participating?
 
BradleyClevelandConnect With a Mentor Author Commented:
The problem appears to be when the form or report is in design in Office 2010 and the font assigned to a section of the object is a "theme" font rather than a named font.  Evidently something has changed in either Windows or office so that on some computers when the program is run, Access doesn't know what to do with a Theme font.  So the fix appears to be to set all fonts as Named.  Now the problem will be finding a way to automatically do this on 1000 reports, and 600 forms.
0
 
pjevinCommented:
My guess is that another user is opening the form and doesn't have Calibri so it's being substituted and it's saving with what they used.  Microsoft is notorious for this, I believe Word uses the next font available Alphabetically if the user's machine doesn't have what is specified.
0
 
BradleyClevelandAuthor Commented:
No. The database is compiled on workstations that have the Calibri font and on workstations that are substituting the font, I looked and they have Calibri.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Does this happen on all machines, or only on a few?

If it happens on all machines, then you may have a corrupt database. To try and fix that, create a new, blank database and import everything into that new database, then deploy that new database.

If it only happens on one machine, you may have some issues with Office or Windows. Be sure both are fully up to date. Sometimes a repair/reinstall of Office is needed for issues like this.
0
 
BradleyClevelandAuthor Commented:
I found what is causing the formatting change even though I never found out the reason all of this started all of sudden.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.