Format Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have Date field, so if i type a date it should show short date and medium
time.
I select in the form General Format and it's not working.
How can I view both same time?

Thanks
 
I have Date field, so if i type a date it should show short date and medium
time.
I select in the form General Format and it's not working.
How can I view both same time?

Thanks
Click to expand...

You're not limited to one of the formats shown in the drop-down list.
Write your own date/time format.
On the Format property line, write:
mm/dd/yyyy h:nn AM/PM
 
Thank you so much.

fredg said:
You're not limited to one of the formats shown in the drop-down list.
Write your own date/time format.
On the Format property line, write:
mm/dd/yyyy h:nn AM/PM
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Medium Date format and calendar in Access 2007 1
#Type! error on form 6
Field Format: Combining standard date/time formats 1
Changing a Medium Time 5
Date format automatically changed 1
Access General Date Forced To Have Date And Time 2
Cannot enter time in form 4
Forcing a date entry format of dd/mm/yyyy 1

Back
Top