I have a form with a Tab control and under a certain
condition I would like to either change the color of a
Page or change the color of the text(even just make it
bold would be fine). I can't seem to find the properties
or the proper syntax to do this any ideas?

This is essentially the login I want:

If condition Then

Me.myTab.MyPage(1).BGColor = vbRed
or

Me.myTab.MyPage.Text = vbRed or Bold
End if


Thanks

The tab control that comes with Access offers no background color property
for the individual tabs.
However, alternative methods are possible. The sample database/code
provided at the below web page should get you started.

http://www.lebans.com/tabcolors.htm



"quixote" <(E-Mail Removed)> wrote in message
news:275501c4ad73$bc79ce00$(E-Mail Removed)...
>I have a form with a Tab control and under a certain
> condition I would like to either change the color of a
> Page or change the color of the text(even just make it
> bold would be fine). I can't seem to find the properties
> or the proper syntax to do this any ideas?
>
> This is essentially the login I want:
>
> If condition Then
>
> Me.myTab.MyPage(1).BGColor = vbRed
> or
>
> Me.myTab.MyPage.Text = vbRed or Bold
> End if
>
>
> Thanks
>

Hello,
I tried to change the TabColor with your function, Steve. But, the MS
Tab-Control only accepts 256Colors-Bitmaps. Try the color 255,253,242 (rgb).
The TabStrip is displayed in white (changing the color of the rectangle of
course is no problem). But not your function failed, the TaBStrip is the
problem. Try to set an 24Bit-image with the standard properties-dialog. The
same effect, the shown image is not the original. I hope you understand my
problem. What can we do? A letter to MS? ;-)

By Frank


"MikeC" <(E-Mail Removed)> schrieb im Newsbeitrag
news:OMC9d.26650$(E-Mail Removed)...
> The tab control that comes with Access offers no background color property
> for the individual tabs.
> However, alternative methods are possible. The sample database/code
> provided at the below web page should get you started.
>
> http://www.lebans.com/tabcolors.htm
>
>
>
> "quixote" <(E-Mail Removed)> wrote in message
> news:275501c4ad73$bc79ce00$(E-Mail Removed)...
> >I have a form with a Tab control and under a certain
> > condition I would like to either change the color of a
> > Page or change the color of the text(even just make it
> > bold would be fine). I can't seem to find the properties
> > or the proper syntax to do this any ideas?
> >
> > This is essentially the login I want:
> >
> > If condition Then
> >
> > Me.myTab.MyPage(1).BGColor = vbRed
> > or
> >
> > Me.myTab.MyPage.Text = vbRed or Bold
> > End if
> >
> >
> > Thanks
> >
>
>

This limitation is documented in the commented source code behind the
sample Form. There is no workaround that I could find.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Frank Schlüter" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> Hello,
> I tried to change the TabColor with your function, Steve. But, the MS
> Tab-Control only accepts 256Colors-Bitmaps. Try the color 255,253,242
(rgb).
> The TabStrip is displayed in white (changing the color of the
rectangle of
> course is no problem). But not your function failed, the TaBStrip is
the
> problem. Try to set an 24Bit-image with the standard
properties-dialog. The
> same effect, the shown image is not the original. I hope you
understand my
> problem. What can we do? A letter to MS? ;-)
>
> By Frank
>
>
> "MikeC" <(E-Mail Removed)> schrieb im Newsbeitrag
> news:OMC9d.26650$(E-Mail Removed)...
> > The tab control that comes with Access offers no background color
property
> > for the individual tabs.
> > However, alternative methods are possible. The sample database/code
> > provided at the below web page should get you started.
> >
> > http://www.lebans.com/tabcolors.htm
> >
> >
> >
> > "quixote" <(E-Mail Removed)> wrote in message
> > news:275501c4ad73$bc79ce00$(E-Mail Removed)...
> > >I have a form with a Tab control and under a certain
> > > condition I would like to either change the color of a
> > > Page or change the color of the text(even just make it
> > > bold would be fine). I can't seem to find the properties
> > > or the proper syntax to do this any ideas?
> > >
> > > This is essentially the login I want:
> > >
> > > If condition Then
> > >
> > > Me.myTab.MyPage(1).BGColor = vbRed
> > > or
> > >
> > > Me.myTab.MyPage.Text = vbRed or Bold
> > > End if
> > >
> > >
> > > Thanks
> > >
> >
> >
>
>