PM Time Only - Access 97 1

[donnadee]

I have created a medium time field in an Access97 database.
The field is TimeClosed. 99% of the records will have times that close in the PM.

Access automatically fills in AM at the end when users type 5:00

Can this be reset to make it autofill in PM instead of AM as the preference? Thanks in advanced.

 

[mgolla]

Yeah,

Create an input mask: 99:00" PM"

HTH
Mike

 

[donnadee]

mgolla,

I created the mask on the form and as soon as I tab through, it reverts to AM still. I also tried the input mask in the table, but still reverts to AM.

I want to type 9:00 and have it convert to 9:00 PM

Should I drop medium time?

 

[mgolla]

Try this instead,

Remove the InputMask and on the AfterUpdate of the field put this code

Field1 = DateAdd("h",12,Field1)

Leave the Medium Time format on it for it to work

HTH
Mike

 

[donnadee]

Thank you mgolla !
That worked well.