format check of input box

[jattman]

i have a input box on a form and i want to check that the data entered is in the format of "mm/yyyy"

If Date_input.Format = "mm/yyyy" Then
MsgBox ("Yes")
Else
MsgBox ("No")
End If

The yes and no msgbox's are just there so i know it works.

thanks in advance

 

[bradcccs]

You can use the "Format" & "Input Mask" properties to achieve this.

Format: mm/yyyy

Input Mask: 00/0000;0;_


hth

Brad