make label visible dependant on date

[Toolpusher]

I have a form with a overdue date on it , also have a overdue warning label that I have set to not visible. I want it to appear on the form when that date is now or past not sure how to achieve that?

 

[pbaldy]

I would use Conditional Formatting on a textbox (I don't think it will work on a label).

 

[Toolpusher]

Well got it to run by putting this on the load event of the form If Me.[Due Date] <= Date - 3 Then Me.Label248.Visible = True

I know thats rubbish but it does make the 248 label visible trouble is its visible for due dates in the future

Just want it visible on records that are 3 or more days past their due date

 

[pbaldy]

Code is not going to give you the look you want in continuous or datasheet view. If it's in single form view it can work, but you'd want it in the current event plus you need an Else clause to handle the other side of it.