Restrict Previous Date

[Peter]

Hi all,

Access 2007.I am using this code in the Before update event of a date field:

If Me.[Due] <MyDate Then
MsgBox "bla bla"
Cancel =True
End If

The Forms date field is formatted dd-ddd-mmm-yyyy so is the table field..but
the code does not fire...what am i doing wrong. I replaced Mydate with
Date()..but access refuses to save Date()..it saves only Date..

Thanks for help!

 

[John W. Vinson]

Hi all,

Access 2007.I am using this code in the Before update event of a date field:

If Me.[Due] <MyDate Then
MsgBox "bla bla"
Cancel =True
End If

The Forms date field is formatted dd-ddd-mmm-yyyy so is the table field..but
the code does not fire...what am i doing wrong. I replaced Mydate with
Date()..but access refuses to save Date()..it saves only Date..

Thanks for help!

Date (without the parentheses) is in fact correct in VBA code; it calls the
builtin Date function (unless you unwisely have a variable named Date!)

It's possible that whatever Due contains is being interpreted as text rather
than as a date/time value. Try

If CDate(Me!Due) < Date Then

to check for Due being earlier than midnight on the previous night. Use

If CDate(Me!Due) < Now Then

to check for the textbox containing a date/time value in the past (even one
second in the past!)