Tab controls

[swift]

Following on from bob fitz's advice http://www.access-programmers.co.uk/forums/showthread.php?p=1110200&posted=1#post1110200, I was wondering if its possible to do the following: scenario is 2 checkboxes on a sub-form which sits on a tab control. If both boxes are unchecked, the tab control is coloured red; if one is checked without the other the the tab is amber, and if both are checked then the tab is coloured green.

I'd like to say that I'd had a go at this but I'm not even sure if its possible - any thoughts/advice most welcome.

Cheers

Swift

 

[missinglinq]

Just to be clear, do you want to change the Back Color of the the entire Tabbed Control, a single Tabbed Page of the Tabbed Control, or the Tab itself?

Linq ;0)>

 

[swift]

missinglinq, its the tab itself I'm looking to colour - to give a user a quick status 'snapshot' of the information on the form. Sorry, I should have been more clear at the start, thanks

Swift

 

[missinglinq]

The Back Color for Tabbed Controls, including the Tabs themselves, is determined by settings in Windows on your PC. What you can do is

1. In Form Design View go to Properties - Format and change the Style Property from Tab to None
2. Replace the now gone Tabs with Labels
3. Code the OnClick event of each Label to navigate to the appropriate Tabbed Page
4. Using the AfterUpdate events of each Checkbox and the Form_Current event to do your Conditional Formating, changing the Label's Back Color as is appropriate.

If you can live changing the color of each Tabbed Page, which will, of course, also change the color of the Tab itself, here is a link to hack for doing that with explicit instructions:

http://www.fontstuff.com/access/acctut12.htm

I assume this code could be modified to change the colors Conditionally.

As you may have figured out by now, this is not going to be a trivial undertaking, whichever approach you decide to take. To me it would be more work than it worth, but everyone has their own needs!

Good Luck with your project!

Linq ;0)>

 

[swift]

missinglinq,

sorry for the delay in replying, I've been trying to get the basics down first in the database before I even attempted this. As you've noted it seems to be quite complicated and I think its a bit beyond what I can do (and what the database needs) at present. Definitely an aspiration though!

Watch this space!!

PS cheers for the help!

 

[missinglinq]

We all like to produce nice looking apps, of course, but in the end our first concern has to be producing one that

• Does the job correctly
• In as little time as possible
• Causes as little angst as possible on the part of the users

Especially when looking at cosmetic stuff, you really have to balance what you'd like to do against how much time and effort it's apt to cost you!

Linq ;0)>