Problem with entering birthdays eg. 01/02/19

[morlan]

Hi all,

When I enter a birthday in my form as 01/02/09 it enters it into the database as 01/02/2009 but I want it to be 01/02/1909,

Is there a way of making sure that access never enters dates that are this century? Should I change there field types to text instead of date/time?

Thanks

 

[Rich]

Change it to the 4 part year digit

 

[morlan]

Change it to the 4 part year digit

The table is on an SQL server. I'm using an ADP file. How do I change to 4 part year digit in table design view?

 

[Rich]

Can't help on that one, sorry