Results 1 to 8 of 8
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Change default font in form design (Access 2003)

    I was asked the question the other day where to change the default font used in form design view. On the persons PC, when they create a new form in design and they add a text box control, the font in the toolbar is MS Sans Serif. They want it to Arial so that it gives more font size options and looks nicer. I notice that Table and Query default fonts can be changed in Access using the Tools | Options dialog, but there is nothing under the forms tab to do the same?

    Any ideas?
    TX
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Change default font in form design (Access 2003)

    One option is to update the Standard autoformat for forms:
    - Create a form, and if necessary apply the Standard autoformat to it (Format | AutoFormat).
    - Create a label, text box, combo box, list box etc. on the form and set the preferred font for them.
    - Select Format | AutoFormat again, and click Customize...
    - Select the option to update 'Standard' with the values from the current form (see screenshot)
    - Click OK.

    It's also possible to specify an existing form as the template for new forms in the Form/Report tab of Tools | Options...
    Attached Images Attached Images
    • File Type: png x.PNG (10.3 KB, 8 views)

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Change default font in form design (Access 2003)

    Thank you. This makes sense. The standard autoformat is probably the basis for new forms. If you change this then it should be used on all subsequent forms...
    Cheers!
    Regards,
    Rudi

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Change default font in form design (Access 2003)

    Access "remembers" which AutoFormat you apply. When you create a new form in design view, it'll apply the same AutoFormat as last time. So if you last used Standard, it'll be used for the next new form too. I don't like any of the other built-in AutoFormats, so I never use those...

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Change default font in form design (Access 2003)

    <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>...I agree. (The only two that are worth their design possibly are "Expedition" and "Sumi Painting")
    Cheers
    Regards,
    Rudi

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Change default font in form design (Access 2003)

    Access 2007 has new and much better looking AutoFormats - see here.

  7. #7
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Change default font in form design (Access 2003)

    Everything about Office 2007 is better.... of that which I have seen already, the formatting is amazing...and those toolbars (which are now called ribbons...)

    PS: Have you seen the options in Excels conditional formatting....now even icons can be assigned to cells to indicate a conditional match...

    I think we are going to have fun with the improvements in 2007....esp with what WOPR can now send as answers to questions!!!!
    Regards,
    Rudi

  8. #8
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Change default font in form design (Access 2003)

    Office 2007 may be less appreciated by some long-time Office users, since all their familiar menus and toolbars have been replaced with context-sensitive ribbon panels. I know I dislike the ribbon, and I've heard the same from many other Access developers. There are others who think it's wonderful, so don't take my word as final. It is a radicaly departure from the standard "Microsoft" interface and a switch to something more Mac-like.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •