I have a need in a database to have the date entry entered in the format dd/mm/yyyy. The Regional and Language options for dates are set for a short date to be mm/dd/yyyy. This is because in most cases that is what is needed.
The property for the form control for this date entry is as follows:
Format property: dd\/mm\/yyyy
Input Property: 90\ /90\ /0000
I expect the control to allow the entry for March 1, 2003 to be entered and displayed as 03/01/2003. It accepts that key entry as such but then after the tab process it re-arranges it as 01/03/2003. It does this all the way through an entry of 12/01/2003( re-arranged for display as 01/12/2003). But, as soon as you enter the first 2 digits, which should be recognized as the dd or day value, as a value greater than 12 the format works correctly. It seems as though ACCESS gets confused by the input and makes assumptions that are wrong, even though the Format property should be making it quite clear which digits are the months and days.
Anyone ever seen this problem. Bob Scriver
The property for the form control for this date entry is as follows:
Format property: dd\/mm\/yyyy
Input Property: 90\ /90\ /0000
I expect the control to allow the entry for March 1, 2003 to be entered and displayed as 03/01/2003. It accepts that key entry as such but then after the tab process it re-arranges it as 01/03/2003. It does this all the way through an entry of 12/01/2003( re-arranged for display as 01/12/2003). But, as soon as you enter the first 2 digits, which should be recognized as the dd or day value, as a value greater than 12 the format works correctly. It seems as though ACCESS gets confused by the input and makes assumptions that are wrong, even though the Format property should be making it quite clear which digits are the months and days.
Anyone ever seen this problem. Bob Scriver
