Calendar field date default to 19xx instead of 20xx

[perryc]

How do I set the two digits years to 19xx instead of 20xx. e.g. If I enter 01/01/22, it defaults to 01/01/2022 but I want all these to go to 19xx. I know I can put "19"00 in the format field, but they, I can not change it to 20xx if it happens. Any idea?

[Welshgasman]

You need some sort of rule to decide whether is should be 19xx or 20xx.
Or you can stop being lazy and enter the other 2 characters?

[CJ_London]

Perhaps set the default value to a date in the 20th century? User can then use the calendar more easily or just replace the day, month year part. Perhaps set the format to the iso standard of yyyy-mm-dd so user does not have to skip over the 19

another alternative if you do not have matching years (e.g. 1919 and 2019) have a calculation in the control afterupdate event - something like

txtdate=dateadd(“yyyy”,(txtdate>date)*100,txtdate)

all depends on the date range you are entering

[perryc]

ty all for the insight. I will Try CJ's suggestions. Ty

[June7]

Beware of code posted with smart quotes - those slanted quotes and apostrophes. Access won't like them if you copy/paste that code.

[CJ_London]

Good point - keep forgetting when responding from phone

[Welshgasman]

Interesting,
When I post from the phone I get "test".
I am on Android?

[CJ_London]

I use an iphone. So far as I know you cannot select a characterset to exclude the smart quotes