Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Access Form - Formatting Tab Control

Posted on 2011-02-13
8
Medium Priority
?
567 Views
Last Modified: 2012-05-11
I'm using Access 2002 and I've inserted a Tab Control on my form to placr subforms.  The tab control is sitting on a white area of my form.  I would like to adjust the formatting of the control to remove the default grey color and to adjust the fore color of the tabs to a different color.  I've been able to make the background of the tabs transparent, but there's still a grey bar across the top and the tabs are still grey.  I'm prob overlooking something very obvious, but here's what I want to change.

a) make the tab control "flat" vs the "raised" appearence it has now.
b) make the entire tab control either white (including tabs, background, etc.) or transparent.
c) change the fore color used on the tabs so it can match the rest of the font color used on the form.

I appreciate any help with this.
0
Comment
Question by:vsllc
8 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 2000 total points
ID: 34883367
AFAIK ... this is the only option when it comes to tab enhancement (free):

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

mx
0
 
LVL 21
ID: 34883680
You can set the tabs to any color you like as long as it is  gray.   :)

The short answer is  you can't change those setting, like tab color, with the built  in tab control  in Access 2002/2003.  It is very limited in what you can do to change appearance.

If you upgrade to Access 2010 you will have a few more options.






.


0
 
LVL 75
ID: 34883686
However, the Lebans app does work ... includes demo db

mx
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
LVL 21
ID: 34883715
Stephen Lebans did create a cool class that would add new features to the built in tab control.

Note: Even though it is in Access 97. It can be convert to Access 2000 - 2010 without any issues.
0
 
LVL 75
ID: 34883728
Exactly. I've tested it.

mx
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34884510
0
 

Author Comment

by:vsllc
ID: 34885294
Interesting that it's not a built in formatting feature in this version.  The lebans app looks like it will do what's needed.  Will be upgrading to 2010 shortly so this should no longer be an issue.

Thanks for the advice.
0
 
LVL 21
ID: 34885480
Just not worth any points?
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

782 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question