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?

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...

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...

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.