How to highlight single tab

[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

 

[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

 

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