Displaying a lable by date

[techkenny1]

Hi

Is it possible to have a label display by date.
On a form I need a lable (invisible) to display at the end of each month and display that label for just one day.

Many thanks,

 

[Remou]

You can use the Load Event or the Current Event for the form, depending on which best suits:

Me.lblWarning.Visible=(Date()=DateSerial(Year(Date), Month(Date)+1, 0))

http://lessthandot.com