Link to home
Start Free TrialLog in
Avatar of Joanne Bailey
Joanne BaileyFlag for Canada

asked on

Access 2010 change tabbed window color

Access 2010: I have an On Click event to create a report that also opens up to 3 tabbed windows (select query results with issues to be resolved) during report creation. Upon completion, the report is in focus. I would like to change the color of those select query tabs(to make them stand out). Because there could be more than 1 I can't use Set Focus (which automatically changes the tab color) so I am wondering how to do this?
Avatar of IrogSinta
IrogSinta
Flag of United States of America image

I can't visualize this. What s do you mean by select query tabs?  Can you upload an image?
Avatar of Joanne Bailey

ASKER

screen shot attached as requested. In Access Options, Document Windows Options I have Tabbed Documents selected (not overlapping windows). Therefore, in my screenshot you see the tabs of all of the windows that are open. The orange tab is the active window which is the report. The next tab is the tab "ResolveCamsOwner" is the one that I want to change the tab color or the tab font color to make it stand out. There could be more than one of these tabs (which are actually select queries) that I want to change color so simply changing SetFocus to "ResolveCamsOwner"  is not an option. I can't find a property to change the back color or font color on these tabbed windows. You would think it would be with the Format properties where the Caption can be changed so does that mean this is not supported in Access 2010 and, if so, has someone developed a work-around?
screen-shot-for-EE.PNG
As a developer, when you present these items to be resolved to the user, you should be creating an interface for them and not allow them access to the tables and queries in this manner where you have no control of anything they do in the database.
this particular report is for the data admin group who does the clean up
Dear Experts: Can someone answer the question: How do you change the colour of the tab or font on tabbed windows? I find it annoying that someone who is a developer would rather comment on what I shouldn't be doing when they don't know the slightest thing about the requirements, who the user is and the source of the data being presented (it is not the production database tables!)
this particular report is for the data admin group who does the clean up
If you had included more information from the start I wouldn't have given you that advice. The majority of questions here have to do with presenting data to a user so that was my assumption.  Since I was just posting from a phone, I just wanted to give you some quick advice and I was going to upload a sample on how to do this later when I got back to my computer.  Apparently that sample is irrelevant since that is not what you need.

With regards to your original question, I don't think that's possible; however, I will ask the other experts to check in on this question.  Maybe they will have some other insight.
Can someone answer the question: How do you change the colour of the tab or font on tabbed windows?
It is not possible.
Agree with HiTechCoach - you can't change the colors of the tabs in the Access interface. As far as I know, there is no workaround other than to create your own interface (as IrogSinta has already suggested).

<soapbox>
And we find it annoying that you would post rants about the VOLUNTEER Experts. Doing so  will certainly not encourage other Experts to help you. We understand you're frustrated and looking for help, but you certainly won't find many willing to help if we perceive a hostile or negative attitude.
</soapbox>
ASKER CERTIFIED SOLUTION
Avatar of Bitsqueezer
Bitsqueezer
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I will definitely try this and let you know. Thank you!
JoanneSB,

Would you mind sharing your solution?