Date Picker Option Not Available For Unbound Text box

**data808** · 03-09-2014, 02:03 AM

I changed this text box format to General Date but I do not have the date picker icon when I click on the text box. I also noticed that for this text box in the property sheet, it does not even have the date picker option listed. Does anyone know why? I am trying to do this in a report header.

**AlexHedley** · 03-09-2014, 02:22 AM

You could use the got focus event:

Code:

DoCmd.RunCommand acCmdShowDatePicker

**data808** · 03-09-2014, 02:35 AM

Thanks AlexHedley,

but it says that its not available right now. I think that command is not available in a report. Thats what it seems like to me anyway. I guess I will have to find another solution. Thanks for the help anyway.

**AlexHedley** · 03-09-2014, 02:19 PM

I'd missed the Report part.

Why do you need it in a Report?

Select your parameters in a Form then open the Report based on your selection.

Date Picker Option Not Available For Unbound Text box

Thread Tools