Data Validation

[Traci]

I am new to access and absolutley not a programmer, and I am sure this is a very simple fix. There is some validation in the code that requires a schedule number to be only #'s, so the code reads...

If txtSchedule.Text Like "######" Then
editSchNum = txtSchedule.Text
Else
MsgBox "please enter a schedule# with 7 characters"
Exit Sub
End If
End If..

The format of the schedule #'s has changed and there needs to be an alpha as the third digit. I thought I could replace one of the #'s with a ?, but its still not working...

[Traci]

OMG ok my bad guys. I was not able to delete the post. Ever look at something and you miss the minor details. Sorry.