By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,816 Members | 2,151 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,816 IT Pros & Developers. It's quick & easy.

How to color tab of tab control when content of tab meets generic criteria

P: n/a
I have an MS Access form that uses a tab control with multiple tabs.
On each tab, there are various fields.

How can I color-- or if easier add some simple icon--to a particular
tab (say tab 2 of 5 in the tab control) if a field on tab 2 meets some
generic criteria like salary field is > 50000. I'm trying to give the
operator a visual cue that tab 2 contains important data that should
be reviewed--so the operator does not have to visit each tab to
manually inspect all fields (which may contain only nominal values).
If I could color tab #2 red or mark just tab #2 with an icon, then the
operator would know to navigate to tab #2 specifically.

Please include all VB/code and tell me which event to use/how to
attach.

Thanks Access gurus.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You could create a Bitmap that you would set as the Picture property of
the desired TAB Page.
Perhaps using the form's Current event you could do something like:

If Me.txtSalary >50000 then me.TabControlName.Pages(0).Picture =
"C:\LookAtMe.bmp"
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Scot Balfour" <ga******@aol.com> wrote in message
news:72**************************@posting.google.c om...
I have an MS Access form that uses a tab control with multiple tabs.
On each tab, there are various fields.

How can I color-- or if easier add some simple icon--to a particular
tab (say tab 2 of 5 in the tab control) if a field on tab 2 meets some
generic criteria like salary field is > 50000. I'm trying to give the
operator a visual cue that tab 2 contains important data that should
be reviewed--so the operator does not have to visit each tab to
manually inspect all fields (which may contain only nominal values).
If I could color tab #2 red or mark just tab #2 with an icon, then the
operator would know to navigate to tab #2 specifically.

Please include all VB/code and tell me which event to use/how to
attach.

Thanks Access gurus.


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.