• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 159
  • Last Modified:

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.
0
BradleyCleveland
Asked:
BradleyCleveland
  • 3
1 Solution
 
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:
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
 
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now