Validation Problem in vba text box

Question

I want to validate a text box

where the user enters the date in format dd/mm

and time hh/mm

in the same text box

how to do this?

Answer 1

There is no simple way to achieve this. There are a couple of complicated ways.

You can make the control unbound, then write a handler for the After Update event of the control. In this handler, you will need to validate the user's entry, create a date value from the entry (presumably defaulting the year to the current year), and assign that value to the field storing the date. In addition, you will need an OnCurrent event on the form, where you will set the value of the unbound control to be the appropriately-formatted text version of the date of the current record.

Note that this method won't work in a Continuous form, only on a Single Form.