Tab flag to indicate presence of information

[ptaylor-west]

I have 3 note fields which are selected by a tab. Is there a way that I could use some sort of flag or indicator to indicate that the note field contains information. For example change the colour of the tab to red if the note contains information, it would save having to click each tab to see if there is any info present or not.I think using a Is not Null condition could be a point in the right direction.

 

[AlanS]

You could set up controls on the form itself (outside of the tab control), and set their ControlSource properties to some expression which tests the value of the note fields. For example, if you set the ControlSource of txtFlag1 to:

= IIf(IsNull(txtNote1, "", "See Note 1")

it will indicate the current state of txtNote1. If you want to get fancier, you could use event procedures to make the same sort of test, and then set some control's ForeColor or other property as appropriate; if you go that route, you'll have to make sure you have all the appropriate events covered; I would think that would include OnActivate (for when each record comes up in the form) as well as any events necessary to trap updates or deletions in your note fields.

 

[ptaylor-west]

Thanks, I'm sure what you have suggested will work.