How to highlight single tab


G

GA

Hello,

I've got a main form based on 'customers' and a tab control holds all the
sub-forms and non essential stuff.

One of the tabs is for notes & comments. This tab is not the first one
i.e. not visible until selected and I'd like to highlight it in some way
*if* a record exists in the sub form on the tab.

Is it possible for instance to embolden or change the colour of the text
on that tab on the fly?

I want to avoid the possibility of breaking the form with missing
references so I suspect the answer is going to be "No" but you never know
:^)

Thanks
GA
 
Ad

Advertisements

D

Douglas J Steele

Seems to me that Stephen Lebans' TabColors sample can be done dynamically.
http://www.lebans.com/tabcolors.htm


"GA" wrote in message

Hello,

I've got a main form based on 'customers' and a tab control holds all the
sub-forms and non essential stuff.

One of the tabs is for notes & comments. This tab is not the first one
i.e. not visible until selected and I'd like to highlight it in some way
*if* a record exists in the sub form on the tab.

Is it possible for instance to embolden or change the colour of the text
on that tab on the fly?

I want to avoid the possibility of breaking the form with missing
references so I suspect the answer is going to be "No" but you never know
:^)

Thanks
GA
 
Ad

Advertisements

G

GA

Thanks for the reply. I downloaded the example and went weak at the knees
when I looked at the code. However looking at the included forms, it
struck me that I could do what I wanted very easily.

I never think to use the form header/footer but as my tab control is at
the very top of my form that's what I've done. A very small form header
with a red rectangle above the relevant tab and in the form 'On Current' I
check to see if the comments field in the subform >"" and set the
rectangle visible or not accordingly.

Not very elegant but it does just what I wanted to achieve.

GA
Seems to me that Stephen Lebans' TabColors sample can be done dynamically.
http://www.lebans.com/tabcolors.htm

"GA" wrote in message


I've got a main form based on 'customers' and a tab control holds all the
sub-forms and non essential stuff.
One of the tabs is for notes & comments. This tab is not the first one
i.e. not visible until selected and I'd like to highlight it in some way
*if* a record exists in the sub form on the tab.
Is it possible for instance to embolden or change the colour of the text
on that tab on the fly?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top