I have a form which requires the use of tabs. The type data on those tabs will change from record to record, so I'm wondering if the tab page name can change to reflect the value in a control on each tab. Which control to tie the name to is consistent -- but the value within is not.
Suggestions, or am I out of luck on this one?
Hi,
What version of Access are you using? Please remember to select the version number when posting questions in case it becomes relevant to the discussion.
Yes, that should be possible (I think). Try manipulating the tab page's Caption property.
Just my 2 cents...
What version of Access are you using? Please remember to select the version number when posting questions in case it becomes relevant to the discussion.
Yes, that should be possible (I think). Try manipulating the tab page's Caption property.
Just my 2 cents...
Smarter than the average bear, you are. I appreciate the help. This works exactly as desired:
CODE
If IsNull(Me.S1_D1.Column(1)) = True Then
Me.TabCtl278.Pages("1").Caption = "..."
Else: Me.TabCtl278.Pages("1").Caption = Left(Me.S1_D1.Column(1), 6)
End If
Me.TabCtl278.Pages("1").Caption = "..."
Else: Me.TabCtl278.Pages("1").Caption = Left(Me.S1_D1.Column(1), 6)
End If
Hi,
Glad to hear you got it to work. Good luck with your project.
Glad to hear you got it to work. Good luck with your project.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.