stop selection of past days on datepicker

[Gr3g0ry]

is there a way to stop my user from selecting past/previous days on a date picker ?

 

[isladogs]

You can't prevent the past days appearing in the date picker
However if selected date is in the past you can block it

Something like this where DateControl is the name of your textbox:

If Me.DateControl <Date() Then
MsgBox "Please enter a date in the future", vbCritical, "Date error"
Me.DateControl = ""
End If

 

[arnelgp]

agree with this one, since Date Picker does not exposed any Events or Properties.
you can use three Events of the Control to disallow previous dates:

Dim bolKeyPressed As Boolean

Private Sub Text0_Change()
If Not bolKeyPressed Then
    If Me.Text0.Text <= Date Then
        MsgBox "Only Present and Future dates allowed."
        Me.Undo
    End If
End If
bolKeyPressed = False
End Sub

Private Sub Text0_KeyDown(KeyCode As Integer, Shift As Integer)
bolKeyPressed = True
End Sub

Private Sub Text0_KeyPress(KeyAscii As Integer)
bolKeyPressed = True
End Sub

 

[Gr3g0ry]

thanks guys. all suggestions were tried and all worked.