In my data table, i have a "time" field whos format is "short time" (Military format). The primary user of the database is not all too avid with military conversion, I know its an easy conversion but; well i'll leave it at that.
Because we are a 24 hour facility I want to keep the time in military format but make it easy for this one specific user to enter the data. In the time field on the form I have the format set to "medium time" which when entered, the data converts to short time in the table.
I want to create an Input Mask for the Medium date which is currently __:__ __, what I want to do is have the last two lines display "AM/PM" in the input mask so the user knows what the last set of lines are for.
If that is possible, i'd also like to create a validation rule for the same field as I know something will get inputed wrong and when such case does happen, I want to have an error pop up indicating the field format is HH:MM AM/PM (Medium Time).
My issue with this task at this point in time is the input mask showing AM/PM and the validation rule criteria. Anyone have any reccomendations?
Thanks in advance for any help anyone is able to provide.
Because we are a 24 hour facility I want to keep the time in military format but make it easy for this one specific user to enter the data. In the time field on the form I have the format set to "medium time" which when entered, the data converts to short time in the table.
I want to create an Input Mask for the Medium date which is currently __:__ __, what I want to do is have the last two lines display "AM/PM" in the input mask so the user knows what the last set of lines are for.
If that is possible, i'd also like to create a validation rule for the same field as I know something will get inputed wrong and when such case does happen, I want to have an error pop up indicating the field format is HH:MM AM/PM (Medium Time).
My issue with this task at this point in time is the input mask showing AM/PM and the validation rule criteria. Anyone have any reccomendations?
Thanks in advance for any help anyone is able to provide.
