Any help with a Defult Value and Validation RULE. **MICROSOFT ACCESS**

[jayboi2005]

Hi i am creating a database im ok, just havent used it for years and years. I need a defult value which will add todays date. And a validation Rule that will prevent date entries prior to 1/1/2002

Can anyone please help me!! Thanks Jay

AND MY INPUT MASK IS SHORT DATE

[Kegtapper]

Use [Now] as a default value

[pker walker]

i also need the validation rule plz can some1 help?

[Kegtapper]

i also need the validation rule plz can some1 help?

i also need the validation rule plz can some1 help?

Format mm/dd/yy
Default Value Date$()
Validation Rule =[Text8]>#12/31/01#

The validation rule is used under properties of the TEXT8.text
[IMG]http://www.kegtapper.net/images/Validation.jpg[/IMG]

And that will produce this error
[IMG]http://www.kegtapper.net/images/ErrorMsg.jpg[/IMG]

[pker walker]

set default value as ="date"() if his doesnt work

also if he isnt american he wont want the date format u have specified in post above

[Kegtapper]

his text "Hi i am creating a database im ok, just havent used it for years and years. I need a defult value which will add todays date. And a validation Rule that will prevent date entries prior to 1/1/2002"

Wanted American format

[pker walker]

his text "Hi i am creating a database im ok, just havent used it for years and years. I need a defult value which will add todays date. And a validation Rule that will prevent date entries prior to 1/1/2002"

Wanted American format

1/1/2002 can also be uk :P lmao