Date field

[RUDOLFSUN]

Hi

Access novice here, is there away to make a field only accept a date in a specific format ie yyyy-mm-dd hh:mm:ss. If a date is put in incorrectly say 2008-02-14 :23:59:9 then I would want an error to pop up and to disalow that date being entered

Thanks

 

[gemma-the-husky]

it will

if you design a table with a field of a date/time type

then you will only be able to enter a validdate/time into that field

 

[RUDOLFSUN]

Ok but how do I make it only accept date values of yyyy-mm-dd hh:mm:ss?

 

[GaryPanic]

if on your underlying table that is how you have formated the date - then it will only accept this
so is your table date field set up this way ?- now make your form around the table -you can only enter in on the form the preset value and in the preset way

 

[Dennisk]

It's the input mask you need to set.

for example 00/00/00 accepts 2 digit day, month and year

 

[RUDOLFSUN]

Brilliant, thanks for that. Stupid question really!