Re: Visible = False based system date/time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jay - 28 Jan 2005 15:29 GMT

Is it possible to set a control's visible property to False based on the
system date and time. Example: If system time >= #05/07/2005# Then
Me!CheckBox.Visible = False
End If

Is this possible? I know that there is a MyDate function but I'n quite sure
of how it's used in this apppication.

Any suggestions will be appreciated.

Thanks,

Reply to this Message

visdev1 - 28 Jan 2005 15:59 GMT

The now() function returns the current system date and time.

If Format(Now(), "Short Date") = "01/28/2005" Then
Me!CheckBox.Visible = False
End If

> Is it possible to set a control's visible property to False based on the
> system date and time. Example: If system time >= #05/07/2005# Then
[quoted text clipped - 7 lines]
>
> Thanks,

Reply to this Message

Dirk Goldgar - 28 Jan 2005 16:10 GMT

> Is it possible to set a control's visible property to False based on
> the system date and time. Example: If system time >= #05/07/2005# Then
[quoted text clipped - 7 lines]
>
> Thanks,

I don't know about any MyDate function, but there's a Date() function
right enough. Your code could look like this:

Me.CheckBox.Visible = (Date < #05/07/2005#)

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message