alfamikefoxtrot
asked on
MS Access -- ability to change backcolor in subset of page-tabs in a single tab-control object
Hi all -- looking for a way to change the background color of a subset of page-tabs appearing in a tab-control object within MS Access. Specifically -- let's say I have an object containing ten pages -- I'd like the clickable tabs of five of them to have a background of yellow or blue) to distinguish them from the others. I'd like to avoid coloring the entire page blue, just the tab itself, but that isn't absolutely critical.
I've surveyed the literature (including what's here on EE) and am concluding that it's likely more trouble than it's worth, but I thought I'd put the question out there to ask the MVPs if you know of a function or procedure that I'm overlooking. This isn't a showstopper for me but it would be nice to be able to do so I can distinguish some elements from others.
Thanks in advance!
I've surveyed the literature (including what's here on EE) and am concluding that it's likely more trouble than it's worth, but I thought I'd put the question out there to ask the MVPs if you know of a function or procedure that I'm overlooking. This isn't a showstopper for me but it would be nice to be able to do so I can distinguish some elements from others.
Thanks in advance!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Too bad Access will no longer open A97 databases.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi guys -- sincerest apologies for not getting back on this in a timely manner - unexpected personal issue involving 1) older son and 2) court, hopefully resolved now. I actually tried a converted Lebans option and it didn't pan out, at least to the extent that it wouldn't take a fair amount of messing with to get to an endpoint. Both Pat and Dale have given me some good options to chew on. Working through code today, will let you know how it goes and then figure out solutions and points.
BTW -- I'd just like to pass a big THANKS to all four of you (Pat, Dale, Joe, and Jim) -- beyond just this single question, each of you have helped me considerably with many questions I've had along the way and your input and knowledge have been essential. I don't think you guys get thanked enough but I wanted to take a minute to do just that. Your input and willingness to help are truly appreciated....!
BTW -- I'd just like to pass a big THANKS to all four of you (Pat, Dale, Joe, and Jim) -- beyond just this single question, each of you have helped me considerably with many questions I've had along the way and your input and knowledge have been essential. I don't think you guys get thanked enough but I wanted to take a minute to do just that. Your input and willingness to help are truly appreciated....!
ASKER
Thanks guys....!
http://www.lebans.com/tabcolors.htm
I've messed with it in the distant past.
If there are API calls (can't remember), you might have to tweak them a bit.
Good luck.