date field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mccoy - 29 Jan 2008 03:32 GMT

i would like to prevent the users to input back dates on the date field on my
dbase

can anyone help me on this

thanks

Reply to this Message

Dirk Goldgar - 29 Jan 2008 03:41 GMT

>i would like to prevent the users to input back dates on the date field on
>my
> dbase

By "back dates", do you mean, dates before the current date? Keeping them
from entering dates before the current could be accomplished by means of a
validation rule like this ...

>= Date()

... set either for the field in the table's Design View, or for the control
in the form's Design View, or both.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message

mccoy - 29 Jan 2008 04:18 GMT

thank you

> i would like to prevent the users to input back dates on the date field on my
> dbase
>
> can anyone help me on this
>
> thanks

Reply to this Message