Create the "illusion" of Colored Tabs on an Access Form ~ DataPig
This video demonstrates a method to simulate colored tabs on a form. This example details the steps to use labels and option groups and textbox with some fancy restructuring and colors to give the appearance of colored tabs. From the users' perspective this is highlighting colored tab functionality which is not available in the standard Access tab control.
NOTE: optionally, if you're using command buttons to switch tabs, you can use a tab control to manage the content so controls aren't on top of each other. The tab control Style can be set to None so the normal tabs don't show. Then on the Click event of each command button, call this code:
Private Sub ChangeTab()
'220814 strive4peace
Dim nColor As Long _
, iValue As Integer
With Me.ActiveControl
nColor = .BackColor 'copy color of button
'button is named with value on the end like cmd_Page2
iValue = CInt(Right(.Name, 1))
End With
With Me.MyTabControl
.PressedColor = nColor
.Value = iValue
End With
This video has been resurrected from an older Access tutorial series by DataPigTechnologies. Even though Access looks different now, the concepts and functionality persist. Thanks to owner, Mike Alexander, for making these videos available for presentation once again. Thanks also to Jack Drawbridge and John Clark for helping get these valuable lessons back online.