TAB Control in Microsoft Access forms

[PJname]

Is there a way that you can change the font size, color, text, etc.. when using the TAB control in a form?

If so, can you send instructions?


Thanks in advance.

 

[VRoscioli]

The Access Tab control has properties for Font Name, Size, Weight, Italic, and Underline. These are found on the Format tab of the properties window for the Tab control (not of the individual pages). The text that appears on the tab of each page can be edited by modifying the Caption property on the Format tab of that page's properties window.


-V

 

[PJname]

Hello VRoscioli,

I have modified the Caption property naming what I want each tab to display.

Is there a way that I can change the font color for each tab?

I discovered how to change the font size, weight, etc.

 

[Remou]

If you want pretty tabs, you are best off switching the tabs off and using labels or other such controls with click events to select the pages.

 

[MajP]

http://www.lebans.com/tabcolors.htm

 

[PJname]

Thanks MajP,

I tried using your coding, but received a compile error on the following:

Compile error:

Method or data member not found


Private Sub Form_Load()
DoCmd.MoveSize 0, 0, 6650, 5200

' Create an instance of our FormatByCriteria class
Set TB = New clsTabs

' You MUST set the CriteriaControl prop
TB.TabControl = Me.TabCtl
' You MUST set the BackGround control
' used to display the current pages background color
TB.BGControl = Me.RecBG
' Parent Form
TB.TabForm = Me

' Set the desired Rotation amount
TB.RotateDegree = 90

' Create the Tabs
TB.MakeTabs

End Sub


Any suggestions?

 

[MajP]

Likely the cause is that your tab control on the form is not named "TabCtl". That would give the error "Data member not found". There is a lot of neat stuff on Lebans web page, but I only looked at the demo and did not actually try to use the class module.