Make control visible by day of the week

[skwilliams]

I have a button on a form that I would like to only be visible on Thursdays.

Is this possible?

 

[boblarson]

Yes, in the form's open or load event you can use:

Me.YourControlName.Visible = (Format(Date(), "mmmm") = "Thursday")

 

[datAdrenaline]

Or ... a regionally independant method ...

Me.YourControlName.Visible = (WeekDay(VBA.Date,1) = 5)

... if you prefer to use constants ...

Me.YourControlName.Visible = (WeekDay(VBA.Date,vbSunday) = vbThursday)

 

[skwilliams]

That worked great!

Thanks.