hide object IF

[TipsyWolf]

hey guys!

i have tab control with 2 tabs and i have OLEunbound object (pasted from Excel) under this tab control so i'd have a pretty nice UI

so now i need to make switches obvious and the only thing i came up with is text color (back is active, white -is not)
but is there a way somehow to visible=OFF when i click the other one.

like if i click Photos, then OLEunbound object under "risk assessment" text would go off (transparent or visible off). and vise versa.

 

[Gasman]

If you set it to Visible = False, how are you going to get back to it?

 

[TipsyWolf]

If you set it to Visible = False, how are you going to get back to it?

i have absolutely no clue, sir )
thats why i asked it.. well, u know, maybe vba or somehting can do the trick

 

[Gasman]

I think what you already have is perfectly fine, or perhaps set it to Red?

 

[TipsyWolf]

I think what you already have is perfectly fine, or perhaps set it to Red?

red for active or not active. let me play with it

i dont know, looks like it doesn't go along with this "blue" color

 

[Gasman]

I would go Red for Active, White for Inactive.
Is there not a property for the background to be set?

What version of Access is that as mine (now 2019) just looks like ordinary tabs?

 

[TipsyWolf]

Is there not a property for the background to be set?

yes, tab control has such options, but it goes along with its rectangular switches so i had to set as transparent so i could use others features

 

[GPGeorge]

I might opt for a gray forecolor, rather than a red or white, for the "non-selected" look.

 

[CJ_London]

you could just use an option group using buttons if the requirement is one or the other - you can hide the frame

you can change the button shape and styles