<div>
One more question ... is there a way to distinguish in then OnChange event between a change that came from selecting a date in the date picker and a change that is the result of typing in the field? Because now it works fine if they choose a date via the date picker but if they try typing a date, the event fires with every keystroke.<br />
<br />
What I'm trying to do is execute code when a date is entered - either be typing or via the date picker.
</div>


One more question ... is there a way to distinguish in then OnChange event between a change that came from selecting a date in the date picker and a change that is the result of typing in the field? Because now it works fine if they choose a date via the date picker but if they try typing a date, the event fires with every keystroke.

What I'm trying to do is execute code when a date is entered - either be typing or via the date picker.

<div>
You could add a check in the OnChange event like this:<br />
<b>If IsDate(Me.NameOfDatePicker<wbr />Control.Te<wbr />xt) And Me.NameOfDatePickerControl<wbr />.Text Like &quot;*/*/####&quot; Then</b><br />
<br />
Ron
</div>


You could add a check in the OnChange event like this:
If IsDate(Me.NameOfDatePickerControl.Text) And Me.NameOfDatePickerControl.Text Like "*/*/####" Then

Ron

<div>
<div class="content wysiwyg-content">
I have a text box for entering a date and it is set to use Access 2010's built-in date picker. Is there an event that fires when someone selects a date via the date picker? When I select a date via the date picker, it updates the date in the field but the before update and after update events of the field don't fire until I try leaving the field. <br />
<br />
Thanks in advance!
</div>
</div>


I have a text box for entering a date and it is set to use Access 2010's built-in date picker. Is there an event that fires when someone selects a date via the date picker? When I select a date via the date picker, it updates the date in the field but the before update and after update events of the field don't fire until I try leaving the field. 

Thanks in advance!

Is there an event when date is selected via date picker in Microsoft Access?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.