MS Access Themed Controls and Sunken Fields Special Effect

I have a form with some fields Special Effect set to Sunken and some set to Flat.  The Sunken effect works when Use Windows Themed Controls is ON but not when OFF.

Other research suggests Sunken doesn't work with Themed Controls,   BUT   I have some controls set to Sunken that remain sunken regardless of the setting of Windows Themed Controls.  It may be that the unaffected Sunken fields have not been changed since upgrading from Access 2003 mdb to 2010 accdb, but it seems to me that it should either work for all fields or none..

Can anyone throw some light on this?

Thanks in advance.

Clive BeatonAccess DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
How did you upgrade the database? If you selected the "Convert" option, you may want to instead try to build a new, blank 2010 database and import everything from the 2003 database. This seems to cure a lot of ills with the conversion process.
Clive BeatonAccess DeveloperAuthor Commented:
I don't remember how long ago.  It was way back last year and I've done a lot of work on it since then, so there's no possibility of creating it again in a blank database.  

Can you think of any general reason why this might happen?
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
< so there's no possibility of creating it again in a blank database.  >

The Import process moves everything over to the new database. You don't have to recreate anything.

I have no idea why this would occur with some controls and not others. It could be a fault of your video driver, among other things. That said, the Themed Controls have long had quite a list of annoyances. This could very likely be one of those annoyances.

Are you certain that your Office and Windows installations are fully up to date?
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

I had the same problem.  And I can reproduce your problem with Windows XP - Access 2003.

If it is still in your forms in Access 2010 - you are going to have to follow what LSMC is advising - you might need to import each form into 2010.

If that does not work maybe more extensive work is needed and redoing your forms is the next option. (Cut and copy could work for many things)
Jeffrey CoachmanMIS LiasonCommented:
If you ask me, the sunken/raised effect was a bit "odd" (for lack of a better description) IMO.
(Like all the Odd" BorderStyle Properties; Dash-Dot, Sparse Dots, ...etc)

Raised controls are always confused with being Buttons.
A Sunken control always looks like a pushed in Button.

I find that this causes user confusion over what is a button and what is a non-button (Textbox, Lable, Rectangle, ...etc)
   "How do I know what I can click on?"

For this reason, sunken/raised controls almost never appear in any user interface,

So in this case, continuing to design with an "unsupported" interface option, might cause you headaches when this "Effect" is no longer supported.
(like the issue you are having now)

Like still continuing to build custom Menus, and Toolbars, when the "Ribbon" is the preferred interface option going forward.
Or like using "Tree" controls when TaskBars are the more modern interface choice.

Can I ask the significance of raise/sunken controls in your application...?


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Clive BeatonAccess DeveloperAuthor Commented:
Hi Jeff,

Thanks for the worthwhile advice.  There's no real significance of the sunken controls it's just that I've always used them and never thought about changing.  However, you make some very good points, so I will change them all to flat.

Thanks again.

Jeffrey CoachmanMIS LiasonCommented:

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.