Dear experts -
This one has me scratching my head.
I want to show the date picker for a date field on a form under certain conditions, but not in others.
I see there is a property 'showdatepicker' available in VBA; apparently the values are 0 (=never) and 1 (=for dates).
I've tried setting these in multiple places (open event, load event, current event) and nothing seems to work. For what it's worth, I've tried changing the property and when I query the value in the immediate window it seems to have been changed to those above.
But the darn date picker still shows up in all cases.
If I go into the form and manually turn the setting to 'never' for the relevant fields, the date picker does not show up in any case.