Solved

Why is Access substituting my fonts

Posted on 2013-05-15
5
140 Views
Last Modified: 2013-12-16
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
Comment
Question by:BradleyCleveland
  • 3
5 Comments
 
LVL 3

Expert Comment

by:pjevin
ID: 39169587
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
 
LVL 1

Author Comment

by:BradleyCleveland
ID: 39171555
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
 
LVL 84
ID: 39184132
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
 
LVL 1

Accepted Solution

by:
BradleyCleveland earned 0 total points
ID: 39280137
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
 
LVL 1

Author Closing Comment

by:BradleyCleveland
ID: 39721033
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

856 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