Solved

Why is Access substituting my fonts

Posted on 2013-05-15
5
145 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 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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

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.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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…

740 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