• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1612
  • Last Modified:

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.

0
Clive Beaton
Asked:
Clive Beaton
  • 2
  • 2
  • 2
  • +1
1 Solution
 
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.
0
 
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?
0
 
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?
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
darbid73Commented:
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)
0
 
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)
:-O

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...?

JeffCoachman
0
 
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.

Clive
0
 
Jeffrey CoachmanMIS LiasonCommented:
OK

;-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now