A
Amit
Hello,
I'm using MS Access ver2000 and Windows XP. I have a form with two bound
text controls - txtStartTime and txtEndTime. Both of them have been formatted
as "Medium Time" and have an Input Mask of "09:00\ >LL;0;_ ".
When I enter a value that does not conform to the Input Mask, I get an error
message that says "The value you entered isn't appropriate for the input mask
specified for this field.".
How do I change this message to say "Please enter the Start Date in proper
format, e.g. 09:00AM" and then have the focus back to the control? I'll
appreciate a detailed answer so that I can understand the mechanics of what's
happening.
Another question. Where would I place the code to check that StartTime is
less than EndTime? I have these controls on a tab-page on the form. Would I
place this code in the AfterUpdate event of both the controls? Or LostFocus?
I'm assuming that I'll place the same kind of check in the OnChange event.
Thank you.
Amit
I'm using MS Access ver2000 and Windows XP. I have a form with two bound
text controls - txtStartTime and txtEndTime. Both of them have been formatted
as "Medium Time" and have an Input Mask of "09:00\ >LL;0;_ ".
When I enter a value that does not conform to the Input Mask, I get an error
message that says "The value you entered isn't appropriate for the input mask
specified for this field.".
How do I change this message to say "Please enter the Start Date in proper
format, e.g. 09:00AM" and then have the focus back to the control? I'll
appreciate a detailed answer so that I can understand the mechanics of what's
happening.
Another question. Where would I place the code to check that StartTime is
less than EndTime? I have these controls on a tab-page on the form. Would I
place this code in the AfterUpdate event of both the controls? Or LostFocus?
I'm assuming that I'll place the same kind of check in the OnChange event.
Thank you.
Amit