Validation rule for time

[jle0003]

I have 2 textboxes; the first is start time and the second in end time. I have an input mask of 00:00;;_ to format to a 24 hour clock. The events will never span over a 24 hour period; therefore, I need a validation rule that will not allow the user to enter a time in the end time textbox that is less than the time in the start time.

My attempts resulted in an error message no matter what I entered.

Help please! Thank you!!!

[RuralGuy]

To what type of field are these TextBox controls bound?

[ssanfu]

Try the attached mdb. Is this what you are looking for?

Instead of the validation rule, I would use an event function (Before update) to validate the data. You have more options available to validate.

[jle0003]

Thanks, Steve!