Thread: [Solved] Date Picker work-around
View Single Post
 
Old 10-14-2014, 07:15 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

I don't think so. You can change a few things with a Date Picker in Design mode by right clicking on Properties, but nothing that would ease navigation to dates years, or even months ago. You could set the default to, say, 1/1/1920, but I doubt that would solve anything.

Date Picker is cute and sort of handy picking dates within a few months of the default like if your default is the current date and you want to choose next Friday.

I like to add neat controls too, but sometimes they're not worth the effort. Even if you could quickly navigate to a given year, does the automation provide any user benefit? Your other go at it, entering day and month and year with list boxes, is creative but is not ergonomic. I know, I've gone down that or similar rabbit holes.

It's far easier to just type in the date though you obviously need to guard against entering a 21st century date when you want one from the 20th century.
Reply With Quote