Create the "illusion" of Colored Tabs on an Access Form ~ DataPig
Channel: LearnAccessByCrystal
Date: 2022-08-14

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.