Create the "illusion" of Colored Tabs on an Access Form ~ DataPig

[@emilythechef]

So many cool lessons I didn't even know about in this video, thank you for the info!

[@LearnAccessByCrystal]

thank you and you're welcome

[@johnclark851]

Just what I was looking for...grazie!

[@LearnAccessByCrystal]

thanks for commenting, John! 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 End Sub

[@OfficeOnly]

Why you don't use new version to office?

[@LearnAccessByCrystal]

this video was made a long time ago but still has valuable information

[@OfficeOnly]

@@LearnAccessByCrystal 🌹🌹🌹