Page Changes 2

[Countymnca]

Hello,
I have a request form a user to modify an existing form that contains 7 pages (tabs) with something that will change when there is data present on each page.Each page has a Caption that needs to remain visible so that users can go to it to enter data. The request is so that users dont have to click on each page to see if there is data already present when answering questions from the public. I can identify one field from each page to key off, but dont know how to proceed or if this is even possible. Anything will work, but I am not seeing much choices other than visible or not. A change of font or color or even a check box on the page caption would work.

Any ideas?


Thanks

 

[dhookom]

Why do you think it has to display in the Caption? You could have indicators above the tab control.

I suppose you could use the On Current and After Update events to change the caption property of the page or pages adding a "*" or similar.

Duane
Hook'D on Access
MS Access MVP

 

[missinglinq]

Replacing your actual control names:

Private Sub Form_Current()
 If IsNull(Me.TargetField) Then
   Me.PageName.Caption = "No Data"
 Else
   Me.PageName.Caption = "PageName"
 End If
End Sub

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[Countymnca]

dhookum,
good idea...I hadnt thought of that. Focused in to much on the Caption I guess. I will five it a shot.

missinglinq,
I may try yours as well to see which works/looks better.

Thanks

 

[Countymnca]

Changing the Caption based on the presence of data worked great. Thanks for the different point of view on this.

 

[missinglinq]

Glad we could help!

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!