Data Validation

socko139

Registered User.
Local time
Today, 12:38
Joined
Feb 22, 2001
Messages
25
Ok I'm not sure if this is a tough one, but I was hoping someone could help me write VB code that validates data. I want to make sure the user is entering in 10:55 AM into a box. That time format? Any suggestions how to validate?
 
Add this as the input mask for the field in table design view:

09:00\ >LL;0;_

HTH

Ian
 
Hey thanks for the suggestion, only thing though is I have the form created in Excel and I dont believe there is anywhere to enter that but actually as VB code to do the validation. I have a text box on a form in excel. Any suggestions?
 

Users who are viewing this thread

Back
Top Bottom