You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
Today’s guest writer is Steve Greenberg.
The recent Access 2010 Theme’s post introduced you to the new Office themes inside Access. Now let’s show you some of the advanced things you can do with themes. The controls we are about to use can all be found to the left of the Design tab once you’re designing a form or report in design or layout view.
In addition to using the out-of-the-box themes, you can also create your own themes. On the Design tab, choose Fonts | Create New Theme Fonts or Colors | Create New Theme Colors. Here’s the dialog for creating your own theme colors.
Once you’ve created your own theme colors, you’ll want to save them for future use. Choose Themes | Save Current Theme. The theme gets saved as a .thmx file to a folder inside your Application Data folder. On my computer, that folder is
Any .thmx files that are located in this folder are available in Access. This means you can share themes with colleagues or even deploy a set of suggested corporate themes via group policy.
For more information about themes, please see this Office Online help article: Apply, customize and save a document theme in Word or Excel Although the content was written for Excel and Word 2007, it applies to Access 2010 theming.
Advanced options for applying themes
By default, if you select a theme in the theme gallery, it applies to all forms and reports in your application and to new forms and reports you create. If you want to only apply the theme to one object or to all the objects with themes that currently match the selected object, use the right-click menu on the theme.
What about Access 2007 AutoFormats?
Although databases built with AutoFormatting will look the same in Access 2010, the AutoFormat feature is not included in Access 2010. Themes have a number of advantages over AutoFormats
What about the Access Theme Colors from Access 2007?
We admit that our choice of terminology here is a bit confusing. The Access 2007 “Access Theme Colors” were designed to make it easy to create an application that blends in with either Windows or with Office. These colors are still fully-supported in Access 2010. They’re just not visible in the color-picker. You’ll have to drop-down the list of available colors to see them.
We hope you enjoyed this post on theming. I’m eager to hear your comments. We’ll continue shortly with some posts about the new controls in Access 2010 forms.
This is one of my favorite parts about themes! I can decide if I'm feeling lavender or blue today...
This is fabulous. I hope the feature works the way masters work with PPT. It will make changes so much easier to propagate.
Great! One of the annoyance we face with multiple versions of Access which doesn't exist in 97 are when user running one version Access to another they have to wait a long time for that version to launch. As a developer we do not have control of other providers Access databases to switch them to use the same version. Are there anything MS Access team can do to prevent this from happening in Access 2010? the delayed time to launch Access makes many of our users un happy.
Quick correction: Alex, the area tester for themes, pointed out that AutoFormats are available in Access 2010 if you add them to the QAT - Quick Access Toolbar. Thanks, -- Steve
Steve Greenberg: There are several bugs in QAT and they make QAT unusable.