Page 1 of 2 12 LastLast
Results 1 to 15 of 21
  1. #1
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Font for Forms & Controls ? (AXP 10.2627.2625)

    The default font for controls in my system is 8 pt MS Sans Serif. How do I change this default to 10 pt Tahoma?

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Default Font for Forms & Controls ? (AXP 10.2627.2625)

    If you want to change the default font on datasheet views, you do that in Tool/Options and click the Datasheet tab where there is a combo box you can set the default font. If you want to change the default font for reports or forms, you do that by changing the Normal template to a form/report that has the font settings that you want. You do that on Tools/Options Forms/Reports. Actually you can change lots of other things beside the fonts using templates. Do a search on "Form and report templates" and choose the "Specify a new template for forms and reports" and then click the For more info button to see further details. Hope this helps.
    Wendell

  3. #3
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Default Font for Forms & Controls ? (AXP 10.2627.2625)

    I'm not aware of any universal settings for controls. I'm not using AXP, in A2K you can designate a form as a template for new forms (other than those created by socalled "Wizard") on the Tools>Options "Forms/Reports" tab, "Form Template" box. Add controls to the template form, set fonts & other settings as desired, then highlight the control or controls you want to standardize and enter "Set Control Defaults" command from Format menu. New forms created w/o assistance of wizard will reflect template form's default control settings. However, template settings are not "retroactive" if you open already existing forms in design view, you'd have to set the default settings for existing forms individually. Same as above applies to report templates.

  4. #4
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Default Font for Forms & Controls ? (AXP 10.2627.2625)

    Hi Mark - AXP does NOT have a convenient way to change the default form template. One can type in a new name, but there is no "Form Template" box.

    There has to be something in the registry that controls this...

  5. #5
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Default Font for Forms & Controls ? (AXP 10.2627.2625)

    Yeah datasheet defaults are obvious.

    AXP has 0 (that is, nil, nada, zilch) on "Form and report templates". The closest that help gets is templates for webpages/document libraries in Team Sites. [It looks like MS is moving to .NET faster than i thought] And there a references to creating an input mask. (???)

    The options under File | Save As are: Form, Report, Data Access Page.

    File | Export is not much help...

    What I wound up doing:
    1. add all of the controls from the toolbox to a dummy form.
    2. select them all.
    3. Change the font size of all the controls
    4. Click Format | Autformat | Customize and save the form as an autoformat option which I called 'Tahoma10'
    5. It seems to work...

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

    Re: Default Font for Forms & Controls ? (AXP 10.2627.2625)

    If there is no "form template" box, where are you typing in the new name? All the Options dialog does is let you point at a form or report and say "this contains the defaults I want to use". The normal defaults are built into Access and have been as long as I can remember, clear back to the ini file days.
    Charlotte

  7. #7
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Default Font for Forms & Controls ? (AXP 10.2627.2625)

    There is a 'Form Template' box which has the word 'Normal' in it. Suppose I want to use the unknown template "Petes"; where is Petes template? i know what i want it to be, i just dont know where it is, or how to make a new one.

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

    Re: Default Font for Forms & Controls ? (AXP 10.2627.2625)

    You don't save a form *as* a template, you simply designate that form to use as a template. Even when you create one and designate it as a template, the only thing you'll see when you create a new form is the background and size that look the same as your template. Any controls you put on the template form are NOT added to your new form. It's only their properties that get picked up form the template, not the controls themselves, if that is of any help to you.

    If XP truly has removed the ability to designate a template form from Tools-->Options, then try naming your form "Normal" and see if its properties get picked up the next time you create a new form.
    Charlotte

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

    Re: Default Font for Forms & Controls ? (AXP 10.2627.2625)

    See my earlier post. You create a new form and set its properties to the colors, size, etc. that you want. You add one each of the controls you want to format and you set their properties to suit. Then you select them all and click on the Format menu and select Set Control Defaults (please note that you can't save 3 different formats for textboxes as the control default, you're limited to one default per control type). Then you save the form. After that, you enter that form name instead of "Normal" in the Form Template box and Access will pick up those properties the next time you create a form. There's nothing to stop you from having multiple form templates and changing them through code if you need to.
    Charlotte

  10. #10
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Default Font for Forms & Controls ? (AXP 10.2627.2625)

    Boy are you correct about the Help in XP - you can't find it by searching. I was working on 2000 earlier today, but now am in my own office. I don't have SP1 installed yet, but I seriously doubt that they fixed the Help file.

    Never the less, there is a help topic if you go to Contents on Help and then drill down to Forms/Creating Forms you will find the third help topic is "Set the default template for forms and reports. Not to be deterred, I went to the web help thinking I would find it there. Nothing, nada, zilch. As Woody fumed months ago, they didn't do enough QC on XP before they released it. Anyhow, the help that is there isn't very informative, but you can make it work, and we do that for large projects. Your approach works, but you have to do it for every form, and every time you add a new control to a form you have to go back and set the font properties. One of the frustrations of technology. Have a good weekend.
    Wendell

  11. #11
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Default Font for Forms & Controls ? (AXP 10.2627.2625)

    HKEY_USERSgobbledegookSoftwareMicrosoftOffice10.0A ccessSettings
    contains a 'FormTemplate' key and the form name as the value. There's some other interesting stuff in there.

    It contains the default font, but the font size is not stored; it's probably hardwired into Access (egads).

    Moving to a different database means I retain the default font, but I lose the default font size for the controls!

    Perhaps there's an ini file that still exists for Access? I will hunt for that next.

  12. #12
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Default Font for Forms & Controls ? (AXP 10.2627.2625)

    Dang - that is counter to the learned behavior of Word!

  13. #13
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Default Font for Forms & Controls ? (AXP 10.2627.2625)

    Access is TOO helpful, ie, is getting in the way.

    There doesnt seem to be any way to specify 'all buttons shall be 1" wide with this font of that size', so even tho i save some 'defaults', Access does its own thing and makes it an Access button, not a Pete's button.

    I wish i had some more control over the GUI aspects, but for that it looks like I will have to write my own ActiveX button. geez.

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

    Re: Default Font for Forms & Controls ? (AXP 10.2627.2625)

    Turn the wizard off and see what happens when you create a button. If you just click the commandbar button in the toolbox and then single click in the form where you want the button, the size and font of the newly created button should match your template. The wizard uses whatever is stored in its own database when it creates one.
    Charlotte

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

    Re: Default Font for Forms & Controls ? (AXP 10.2627.2625)

    Sounds like a problem in Word to me. <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15> You should hang out in Access more. <img src=/S/devil.gif border=0 alt=devil width=15 height=15>
    Charlotte

Page 1 of 2 12 LastLast

Posting Permissions

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