Format Property - Time Data Type

[Valery]

I have a date/time field. I would like to:

Enter time this way and have it show in the form as:
Enter 5 - show 5 PM
Enter 515 - show 5:15 PM
etc.

I would like it to default to PM and not have to select or enter the PM.
How do I enter this format in the table?

TY in advance for your help.

 

[Pat Hartman]

Use an unbound control. In the BeforeUpdate event of the control, you can validate it and format it as a time value that Access will recognize and place that value in the bound field. Since the data entry is being done in a separate unbound control, I would probably lock the bound control to avoid confusion.

 

[Valery]

Don't understand anything you said. Sorry. TY for trying.

 

[catalin.petrut]

Take a look on this thread and see if it helps you.

 

[Valery]

Read all of it - don't think she got her answer either - very similar question to mine. Unlike her though, my boss will accept a lookup. So I think I will give that a try. But it is not the answer I was looking for - I too want to Default the Field to PM and not enter military time.

TY very much - I had missed that post when I searched.

 

[catalin.petrut]

You can use a unbound textbox to enter the date and a bound textbox in witch you use a formula to add 12 hours on the value you entered in the unbound field.