Is it possible to define a default font & color scheme for an access database?

[Lee Weaver]

Is it possible to define a default font & color scheme for an access database?

Something like a theme in frontpage

I want to set a font, default font color and default background color for the entire database. The goal is not to have to set this information every time I create a new form. It's a rather large project, and I am creating many forms.

 

[DCrake]

Simple Software Solutions

First create a blank form with the desired colours and font settings and save it a FrmDefaultSettings

The next time you want to create a new form, open this form in design mode and select File > Save As... give it its new new name this will retain the setting from the default form.

Access does not have the functionality to set templates but this is a quick way to get around this issue.

CodeMaster:

 

[missinglinq]

Access does not have the functionality to set templates...

Actually, Access does! They're called AutoForms!

You can turn any form you have into a custom AutoForm. So create a dummy form with colors and fonts in textboxboxes and labels, ect. then from Design View for the form, goto Format - AutoFormat and click on "Customize." Now check the radio button for "Create a new AutoFormat based on YourFormName." You'll be asked to give the AutoFormat a name, then you're done.

Now, anytime you want to use this same formatting for a form, from the Form Wizard select the AutoFormat, or from form Design View goto Format - AutoFormat and select the AutoFormat you want to use. And here's the best part, you can do this to a form you've already created using another formatting, and it will change that form 's formatting to the newly chosen AutoFormat!

 

[GaryPanic]

even easier - Tools- options will let you set a lot of this by default
...(keep it simple)

 

[Lee Weaver]

Thanks for the info

Thanks for the info. The tools options doesn't help, you are not allowed to use custom defined colors, and I have a corporate "Color" that i'm using. but the ability to add the "autoform" is awesome, and that is the method i am using.

Lee