none
Set default font in Access

    Question

  • Hi all, Access 2007
     
    How can I change the default font for the entire database. It appears that
    MS has Calibri set as the default font for everything, and I prefer Arial
    for tables, queries, forms and reports. I understand that you can set
    whatever font you want and size individually for each of them, but, that is
    really a good deal of work if you have a lot of them.
     
    How can I set the default font for a new database app when first created to
    use only the Arial font for all forms, tables, queries and reports. I have
    looked in the Help and tried to search elsewhere on this, but, have not yet
    been able to find a way to reset the entire application default font to
    Arial instead of MS's preferred Calibri.
     
    Jan :)
     
     
    Monday, August 30, 2010 7:08 PM

Answers

  • Hi Jennifer...here is another very good source of information on this topic
    by Access MVP Allen Browne, which provides how to also create a default
    database for creating new apps, including setting fonts and other important
    defaults for forms and reports.  Just what I was looking for, and I hope
    others will find it useful as well.
     
    Default forms, reports and databases
     
    Jan :)
     "Jennifer Zhan [MSFT]" wrote in message
    news:476438b7-97de-4647-88cc-7435b5198490@communitybridge.codeplex.com...
    > Hi,
    >
    > I think you may create a blank form and report, set up all the defaults on
    > them and then import them into all new databases.
    >
    > One more step to take is to set your templates under Office Button>Access
    > Options>Object Designers to those 2 "default objects" instead of the
    > built-in ones you should get what you want.
    >
    > But if you do not import the default form and report into a database it
    > will automatically use the built-in templates.
    >
    > In addtion, you may refer to these articles:
    >
    >
    > Hope it helps.
    >
     
     
    • Marked as answer by Jennifer Zhan Thursday, September 02, 2010 1:55 AM
    Wednesday, September 01, 2010 10:17 PM

All replies

  • Hi,

    I think you may create a blank form and report, set up all the defaults on them and then import them into all new databases.

    One more step to take is to set your templates under Office Button>Access Options>Object Designers to those 2 "default objects" instead of the built-in ones you should get what you want.

    But if you do not import the default form and report into a database it will automatically use the built-in templates.

    In addtion, you may refer to these articles:

    Hope it helps.

    Tuesday, August 31, 2010 2:38 AM
  • Hi Jennifer, and thank you for your response.  I will do as you suggest and
    see what happens on this end.  Will this same process work in Access 2007
    and 2010?
     
    Jan :).
     
    "Jennifer Zhan [MSFT]" wrote in message
    news:476438b7-97de-4647-88cc-7435b5198490@communitybridge.codeplex.com...
    > Hi,
    >
    > I think you may create a blank form and report, set up all the defaults on
    > them and then import them into all new databases.
    >
    > One more step to take is to set your templates under Office Button>Access
    > Options>Object Designers to those 2 "default objects" instead of the
    > built-in ones you should get what you want.
    >
    > But if you do not import the default form and report into a database it
    > will automatically use the built-in templates.
    >
    > In addtion, you may refer to these articles:
    >
    >
    > Hope it helps.
    >
     
     
    Tuesday, August 31, 2010 3:11 AM
  • Will this same process work in Access 2007 and 2010?
    YES, I think so.
    Tuesday, August 31, 2010 7:05 AM
  • Thanks, Jennifer. I'll give it a try.  Is a way to change the default font
    for existing apps other than manually changing the font on each form, query,
    table and report?  Is there perhaps some means to use a macro or VBA code in
    the On Open or other functions to change the font on forms and reports when
    they are opened?  Most of the existing apps I developed myself and set the
    font for each one as they were created, but, a few apps were started by
    others that I had to take over and finish and they used whatever font was
    the default or selected fonts that are not that easily read. Font
    consistency and makes it easier to view/read forms and run/read read reports
    for the clients.
     
    Jan :)
     
    "Jennifer Zhan [MSFT]" wrote in message
    news:64f36795-99a6-4556-a38e-f0096baca76a@communitybridge.codeplex.com...
    >  Will this same process work in Access 2007 and 2010?
    > YES, I think so.
     
     
    Tuesday, August 31, 2010 5:23 PM
  • Hi Jennifer...here is another very good source of information on this topic
    by Access MVP Allen Browne, which provides how to also create a default
    database for creating new apps, including setting fonts and other important
    defaults for forms and reports.  Just what I was looking for, and I hope
    others will find it useful as well.
     
    Default forms, reports and databases
     
    Jan :)
     "Jennifer Zhan [MSFT]" wrote in message
    news:476438b7-97de-4647-88cc-7435b5198490@communitybridge.codeplex.com...
    > Hi,
    >
    > I think you may create a blank form and report, set up all the defaults on
    > them and then import them into all new databases.
    >
    > One more step to take is to set your templates under Office Button>Access
    > Options>Object Designers to those 2 "default objects" instead of the
    > built-in ones you should get what you want.
    >
    > But if you do not import the default form and report into a database it
    > will automatically use the built-in templates.
    >
    > In addtion, you may refer to these articles:
    >
    >
    > Hope it helps.
    >
     
     
    • Marked as answer by Jennifer Zhan Thursday, September 02, 2010 1:55 AM
    Wednesday, September 01, 2010 10:17 PM
  • Hi Jan,

    Thanks for sharing this gorgeous article. It is much helpful.

    Thursday, September 02, 2010 1:54 AM
  • You're very welcome.  I have known Allen Browne through the MVP program and
    the Access newsgroups for many years, along with many of the other MVPs and
    long time Access contributors, and he, like the others, is very
    knowledgeable and very generous in sharing with others.
     
    Jan :)
     
    "Jennifer Zhan [MSFT]" wrote in message
    news:10dedb23-d40a-4ee5-aa66-d43a368009a7@communitybridge.codeplex.com...
    > Hi Jan,
    >
    > Thanks for sharing this gorgeous article. It is much helpful.
    >
     
     
    Thursday, September 02, 2010 2:07 AM
  • Thank you.  Does this work for the entire db, or only for the one form or
    report the control is on?
     
    Jan :)
     
    "Tech_WW" wrote in message
    news:3c3d529c-7368-4bf2-a692-8d529143729e@communitybridge.codeplex.com...
    > HI
    >
    > Right click on your text within your document (that which has the default
    > you want) and select FONT and then in the dialog box that appears there is
    > a button at the bottom that says DEFAULT. Click on it and it will prompt
    > you to ask if you really want to change the default to this. Click YES.
    >
    > Thanks
    >
    >
    > --------------------------------------------------------------------------------
    > Office 2010
     
     
    Thursday, September 02, 2010 8:01 AM