Text Colour on Tab Caption

[MarionD]

Is it possible to change the colour of the text on the Caption of a Tab, depending on the contents of a field in a sub-form.

I have a "Memo" field in a sub-form on a Tab form. If there is anything in the Memo , I would like the caption to be red - if not black. I can change the the caption itself - but not the text colour.

I'm using this on the on current event of the sub.form

If me.memofield > "" then
me.parent.memopage.caption="No Memo"
else
me.parent.memopage.caption="Memo!"
end if

I've tried .forecolor but no go.

Thanks

Marion

 

[ColinEssex]

I've a feeling it can be done if you put a labelBox over it and then refer to that.

Col

 

[MarionD]

Hi Colin, thanks for the prompt reply.

I am working on a German system - translating the names is sometimes a bit tricky. What is a labelbox? Is it a normal label (in German Bezeichnungsfeld)
I have tried this but I can't get the label on top of the Tab - even if I set the format to "in the foreground" it still dissappears behind the actual tab. Is there some trick to this that I don't know about?

Thanks again
Marion

 

[ColinEssex]

Hi Marion

Actually, I think I may have led you up the garden path on this.

I've just tried it out and I can't get it to work either. I was referring to a normal label by the way.

Strange really, I felt sure it could be done. If I get a result I'll let you know.

Sorry

Col

 

[MarionD]

Thanks anyway Col!
I've compromised temporarily by just putting a label on the main form - close but not pretty! I still need a solution if anyone else is out there-


Marion

 

[Tim K.]

Check the demo Colored Tab out.

Or Tab Control DB

And check the thread at Tab Control

 

[MarionD]

Thanks for the Tip Tim.

It's not as easy as I thought it would be, but at least not impossible!

Marion