Access annoyingly converts mm/dd/yyyy format to mm/dd/yy

[AndrewRice]

I have an .adp with a SQL Server backend. Date of Birth text box is set with format 'mm/dd/yyyy' and input mask '99/99/0000;0;_'.

Now, if a user inputs a birthdate before the Regional Options cutoff - i.e. '4/25/1929' - the value of the text box is '4/25/1919' but if it is after that cutoff - i.e. '4/25/1930' the text box value becomes '4/25/30'.

So the text box sometimes uses the 'mm/dd/yyyy' format but other times converts to 'mm/dd/yy' and when the file is retrieved from SQL server it displays as '4/25/2030'.

Why won't the text box maintain its 'mm/dd/yyyy' format as specified?

 

[Nowell]

Hi,

I had a problem similar to this, usr format like this:

dd/mmm/yy

That will force it to use the date like 25/mar/1960