Disable by date

[guroos]

I would like, for example, to make a control invisible after a certain date.

I tried in the onload event of the form the following:
if date > #10/10/07# then
controlname.visible=false
end if

This did not work. However, I did get some erratic results when trying different formats.

I appreciate anyone pointing me in the right direction.

[MMcCarthy]

Try this ...

Private Sub Form_Load()
 
    If Now() > #10/10/2007# Then
      Me!Command0.Visible = False
    End If
 
End Sub
 

[NeoPa]

Or, if you just want after the date rather than on it too :

Private Sub Form_Load()
  Me.Command0.Visible = (Date() <= #10/10/2007#)
End Sub

NB. The order of the date literal (#10/10/2007#) MUST be m/d/yyyy, regardless of your national settings. This is standard SQL Date format (Literal DateTimes and Their Delimiters (#).).

[guroos]

Thank you very much, works great.

[NeoPa]

No problems. We're glad it worked for you :)