In Access 2007, I was trying out what "AutoFormat" could do for my form. Unfortunately, it seems I am unable to remove the AutoFormat... I never noticed it as an issue in Access 2007 but when I loaded up the db in Access 2010, the form used a different theme. Upon further inspection, I noticed in Access 2010 there is an option in a control's properties that says "Use Theme". Unfortunately, I cannot just mark it as "No" in Access 2010 because then it makes the .accdb to be un-openable in Access 2007. Is there a way to remove the AutoFormat/Theme from a form in Access 2007? Or would I have to remake the form?

This post has been edited by iOsiris: Apr 4 2012, 10:36 AM

I don't have Access 2007, but in 2010 in the Options for the Current Database there is an option called "Use Windows-themed Controls on Forms". See if that option exists in 2007.

Mike

(IMG:style_emoticons/default/welcome2UA.gif)

I've not explored this option, but you could try setting the form template in A2007

From the Office button:
1. Choose 'Access Options'
2. Select 'Object Designers'
3. Find the 'Forms/Reports' section
4. Set the Form Template to 'Normal'

hth

If I recall the use of a template form only affects the defaults for future development, not existing forms and controls.

Mike