Time marches forward... or backward in my situation.

[Dalagrath]

Hello my lovely Access users!



I have a tiny issue that can probably be fixed quickly by the community. It involves time values and form data entry.

So, my end goal is to enter in military time into a form without a colon like so: 1525 (3:25pm) and have the form show this: "15:25" visually but enter the data into the table like this: 1525.

Now, here is where it gets kind of tricky (for me). I want the input mask to not mess with my users having to "eff" with the colon when doing data entry in the form. Oh and did I mention that the table field value has to be a Time/Date?

Please help me solve my dilemna

[161]

I'm pretty new, but I think I can help on this one...

AB:CD

Left( [field] , 2) will give you "AB"
Right( [field], 2) will give you "BC"

In the control source to the field on the form, you will want it to read something like:

Left( [field] , 2) & ":" & Right( [field], 2)

Im not sure on the exact syntax of the & signs, but im pretty sure thats it, or really close!