Datepicker set to short date: displays time?

[sprovoyeur]

Sorry if already asked, couldn't find it in search. Using Access 2007. Have an unbound text box set up to use the datepicker. Works fine but as soon as I click on the text box and it gets the focus, both the date AND the time are displayed in it until the box loses focus, at which time just the short date is displayed as per the format property setting. Does anyone know of a way for the text box to show the short date all the time, not just when the box does not have the focus?

[ajetrumpet]

wow, strange issue.

check your mask settings in the table field. also check any default value. also check any code behind the control's events. something is causing it. it's probably not a bug.

[sprovoyeur]

Thanks very much for the feedback. As you suggested I checked the default value. The issue arises when you set the default value to Now(). Once you do that, even if the format is set to short date, everytime you click on the box the date AND the time appear. You must use the Date() function to set the default value if you are going to use short date as the format.

[ajetrumpet]

well congrats! You just found out something about Access.