Format Date/Time field

I have a field in a table set up as a Date/Time field with the format being General Date.  And then I have a form bound to that table and a date/time field on the form set to General Date.

But the form is only displaying the date and so is the field in the table.

I want it to display, for example, "11/12/2014 5:34 PM (no seconds)

How can I make this happen?
SteveL13Asked:
Who is Participating?
 
SimonCommented:
set the format property of the textbox control

dd/mm/yyyy hh:nn AM/PM (if you're a Brit)
or
mm/dd/yyyy hh:nn AM/PM (if you're in the USA)

See also the MS reference page for this
0
 
SteveL13Author Commented:
Perfect.  Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.