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

[Scot Balfour]

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.

[Stephen Lebans]

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.