Access 2007 to 2010 border colour changes

[poohbear]

This is my very first post, so please be gentle with me!

I have built a system in Access 2007 and have now had to load it onto a machine running Access 2010. All of the forms in the system have a consistent look, with a "sizeable" border and all of the borders have a light blue "shaded" effect, which presumably they have inherited from one of the Autoformats in Access 2007.

I needed to create a new form and I did this on the machine running 2010. Whatever I do I cannot get the form borders to have the "shaded" effect - all I can get are solid colours. I have loaded the Autoformats into a custom ribon and using these I can get the header or detail sections of the form to appear light blue and "shaded" but nothing seems to change the form border.

The only way around this seems to be to create the new form in Access 2007 and then to move it to the 2010 machine - which seems ridiculous.

Any help would be very gratefully received.

Dave

 

[Pat Hartman]

I think you are stuck with that. There was a change between A2003 and A2007 in how "themes" were handled and again between A2007 and A2010. But the A2010 way is far better so if you don't have a lot of forms, you might consider rebuilding the controls (you can just paste your code) using A2010 themes. Unfortunately, themes only apply to new objects. I don't know of a way to impose them on existing objects. Probably because they respect overrides and the "theme" code can't distinguish between a property you overrode and the default for that control. So, it has no way to know whether it should force the default for the new theme or leave the property as is. It would be nice if Access gave us an option to force a theme on a form or report. That would make it easy to convert but they didn't think that far.

Of course A2013 has new themes but at first glance at least they seem to work the same way the A2010 ones did.

 

[poohbear]

Hi Pat,

Many thanks for the fast tresponse to my post - I really appreciate you taking the time.

I'm wondering if I expressed my problem in quite the right way. The problem I have is with the colour scheme of the border around the outside of the form. In Access 2007 these seem to be automatically generated with the normal 2007 light blue "shady" effect. Having initially transferred the system over to Access 2010 these forms kept this shady light blue surround. I am now adding some new forms and would like to keep a consistent look to the application.

The key issue I am having is that I cannot find anywhere a way to change the properties of the border around the outside of the form. And all I can getnow are forms with solid colour borders around them. Strangely, Ijust tried creating a new form in 2007 and then moving the system accross to 2010 and this time it did not keep the shady light blue border around the form. As I have the original forms working in 2010 with the light blue shady borders, there must be a property somewhere which controls this.

I have experimented with Autoformat and Themes and they seem to change everything apart from the form border.

I hoep this explains the problem a bit better.

Dave