Hide Label

[Joe via AccessMonster.com]

I am trying to create a macro that will hide a label on the form until the
form's date passes today's date, then I want it to display a label saying
that the record has expired. Is there any way I can do this in Access 2003?

Thanks In Advance.

 

[Steve Schapel]

Joe,

Change the label to a textbox. You can format it to look like a label.

Then in the Control Source of the textbox, the equivalent of this:
=IIf([YourDateField]>Date(),"Expired!","")

Does that do the trick?