Solved

Why is Access substituting my fonts

Posted on 2013-05-15
5
148 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 85
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

691 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