Time using masked edit control

[rschkrt]

When entering the time, I wanted to use the masked edit control but having a problem. When enter a time example: 10:15:00 AM. How would I mask it? Thank you.

 

[Foada]

Try MyStr = Format(MyTime, "hh:mm:ss AMPM&quot If you choose to battle wits with the witless be prepared to lose.

 

[DangerPowers]

The mask property of the control can be set to ##:##:## ??. However, the control can only distinguish between numbers and letters. The user could enter 99:99:99 XX. You would still have to validate the time with the IsDate() function.

If you are going with an ActiveX control, try the DTPicker in the Common Controls and set the format property to 2 (dtpTime). This provides a text box with and Up/Down control and the user can only enter a valid time.