Color subform tab blue when text is filled

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ielmrani - 18 May 2007 15:03 GMT

Hi,
I am trying to color a subform tab blue or red when 2 of its text boxes are
not null. Here is my code that I tried but it's not working:

If Forms![Centers of Influence subform].First Is Not Null And Forms![Centers
of Influence subform].Last Is Not Null Then
Forms![Centers of Influence subform].Page4781 = RGB(0, 0, 255) 'blue
Else
Forms![Centers of Influence subform].Page4781 = RGB(0, 0, 0) 'black

End If

can anyone tell me what's wrong with my code?
First and Last are the name of the text boxes in the subform.

Thanks in advance

Reply to this Message

Damon Heron - 18 May 2007 18:41 GMT

You can't change the color of tabs. The work around is to select the
tabcontrol style as None, and add an option group of toggle buttons. Then
manipulate the page selection and the toggle font colors with code.
If you want to change the background color, then you will need to create
your own images and use them as buttons.

Damon

> Hi,
> I am trying to color a subform tab blue or red when 2 of its text boxes
[quoted text clipped - 14 lines]
>
> Thanks in advance

Reply to this Message

ielmrani - 18 May 2007 18:52 GMT

Thank you Damon

>You can't change the color of tabs. The work around is to select the
>tabcontrol style as None, and add an option group of toggle buttons. Then
[quoted text clipped - 9 lines]
>>
>> Thanks in advance

Reply to this Message

Peter Hibbs - 18 May 2007 19:39 GMT

If you are trying to change the colour of a Tab control have a look at
http://www.fontstuff.com/access/acctut12.htm

HTH

Peter Hibbs.

>Thank you Damon
>
[quoted text clipped - 11 lines]
>>>
>>> Thanks in advance

Reply to this Message

ielmrani - 22 May 2007 17:36 GMT

thanks.

>If you are trying to change the colour of a Tab control have a look at
> http://www.fontstuff.com/access/acctut12.htm
[quoted text clipped - 8 lines]
>>>>
>>>> Thanks in advance

Reply to this Message