Fix to White Tab Controls in Access 2003?

Hello,
Is there a fix to the Access 2003 problem that makes the tab controls
white? I am confused - I have only seen a couple of posts about this
on various websites. Have others figured out a way to bypass this? Am
I doing something wrong?

I am using Access 2003 on Windows xp. I have a form with multiple
tabs. All the tabs are white - they look horrible. I am embarrassed
to present this to my users. The only thing that gets rid of the white
is to turn XP Themes off. BUT - then the forms don't look as good in
other ways.

When I look at forms on CD's that came with several books I have, they
are ok. When I delete and add back on those forms, they are still ok.
Does it depend on how the forms are created? What am I doing wrong on
my own forms?

Please help - I am tearing my hair out over this one!

Lori

re: Fix to White Tab Controls in Access 2003?

No, I haven't tried changing from the Tabs property. I guess I will
have to do this, as a last resort.
Thank you for the info,
Lori

re: Fix to White Tab Controls in Access 2003?

Hi Justin,
It has been awhile, but I am just now trying to change the style
property from 'Tabs' to 'None', after exhausting all other options.
Can you point me in a direction that explains steo by step how do do
tab controls programmatically? I changed style from Tabs to None. I
added a rectangle to Tab #1, and that got rid of the white background,
and looks great. I made labels to replace the tops of my 6 tabs.

Not sure what else to do now. What do I do with the controls on all my
6 tabs? How do I get the 'tabs' to work?

Thanks,
frustrated Microsoft user
ps - does anyone out there use Access 2003 with win XP? are all YOUR
tab controls white, or am I doing something wrong?

re: Fix to White Tab Controls in Access 2003?

"lorirobn" <lorirobn@yahoo.com> wrote in message
news:1117743977.279465.210960@g47g2000cwa.googlegr oups.com...[color=blue]
> Hi Justin,
> It has been awhile, but I am just now trying to change the style
> property from 'Tabs' to 'None', after exhausting all other options.
> Can you point me in a direction that explains steo by step how do do
> tab controls programmatically? I changed style from Tabs to None. I
> added a rectangle to Tab #1, and that got rid of the white background,
> and looks great. I made labels to replace the tops of my 6 tabs.
>
> Not sure what else to do now. What do I do with the controls on all my
> 6 tabs? How do I get the 'tabs' to work?
>
> Thanks,
> frustrated Microsoft user
> ps - does anyone out there use Access 2003 with win XP? are all YOUR
> tab controls white, or am I doing something wrong?[/color]

Imagine you have a tab control named ctlTab with two rectangles (your 'fake
tabs') named recTabOne and recTabTwo. In your code module you would have
the following:

' --Code Start
Private Sub SelectTab(TabNumber As Long)

On Error GoTo Err_Handler

Me.ctlTab.Value = TabNumber - 1

Exit_Handler:
Exit Sub

Err_Handler:
MsgBox Err.Description, vbExclamation, "Error No: " & Err.Number
Resume Exit_Handler

End Sub

Private Sub recTabOne_Click()
SelectTab 1
End Sub

Private Sub recTabTwo_Click()
SelectTab 2
End Sub
' --Code End


Note that while you are designing your form you could leave the style as
'Tabs' to enable you to select them easily - only switch the style to 'None'
when you have finished changing the layout. This makes it more convenient
to switch between tabs but you could also do this programatically when in
design view. Press ctrl-g to get the immediate window and type in, say,
Forms!MyForm.ctlTab.Value=1 which would select the second tab (the index is
zero-based).

As another possibilty is to have a look at http://www.lebans.com where there
is code to customize the standard tab colours. However, I have not used
this myself.

HTH

re: Fix to White Tab Controls in Access 2003?

Justin,
This is great - thank you so much!
I somehow was able to come up with a solution, after reading your
response, trying what you suggested, and then playing around with the
tabs some more. I ended up being able to put back the 'tab' style, and
then, to each white tab page, I added a large grey rectangle over the
whole page and then 'moved to background'. This rectangle overlaid the
white tab page that I couldn't get rid of!

I can't believe it was that simple... after so many weeks of going
batty from this.
Thank you sooooo much for your help. I never would have gotten this
without it.

Lori

re: Fix to White Tab Controls in Access 2003?

"lorirobn" <lorirobn@yahoo.com> wrote in message
news:1117775676.868571.44100@g14g2000cwa.googlegro ups.com...[color=blue]
> Justin,
> This is great - thank you so much!
> I somehow was able to come up with a solution, after reading your
> response, trying what you suggested, and then playing around with the
> tabs some more. I ended up being able to put back the 'tab' style, and
> then, to each white tab page, I added a large grey rectangle over the
> whole page and then 'moved to background'. This rectangle overlaid the
> white tab page that I couldn't get rid of!
>
> I can't believe it was that simple... after so many weeks of going
> batty from this.
> Thank you sooooo much for your help. I never would have gotten this
> without it.
>
> Lori[/color]


I'm glad it worked - and thanks for the feedback. Often you never find out
whether anyone even read your suggestion, let alone used it successfully.
It's the responses like yours that keep people like me posting!