Microsoft Access form date format

Two questions.
I have a date field with the format of mm/dd/yyyy;h:nn.  When the record is displayed the time is blank until you place the cursor in the field.  How do I get it to display always?

In the field properties I tried placing the above format in the "input mask", but it doesn't work.  I want the user to know how to format the date/time.  How?
datebox.png
J.R. SitmanIT DirectorAsked:
Who is Participating?
 
Gustav BrockConnect With a Mentor CIOCommented:
An input mask is very different from a Format property. It is not very well suited for entering date and time.

You could try with this mask:
00/00/0000 00:00

Study the examples in the on-line help.

/gustav
0
 
Rey Obrero (Capricorn1)Commented:
open the table in design view, select the Date field and set the Format to "General Date"
0
 
Gustav BrockCIOCommented:
Use the Format property of the textbox you use for display. Set it to:

mm/dd/yyyy h:nn

/gustav
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
J.R. SitmanIT DirectorAuthor Commented:
When I enter the date in the field the mask displays but I can't change the time.  When I try to type the time in the text will not change.  I've tried the both the number pad and numbers above the letters.  It won't even let me backspace over the time text.
input-mask.png
0
 
Rey Obrero (Capricorn1)Commented:
upload a copy of your db
0
 
J.R. SitmanIT DirectorAuthor Commented:
@cactus_data.  Yours worked.  Can you send one that will show am/pm?

Thanks
0
 
Rey Obrero (Capricorn1)Commented:
@jrsitman

did you even try my post at http:#a39682665 ?

will give you this result

x
0
 
J.R. SitmanIT DirectorAuthor Commented:
@capricorn1, yes sir I did.  I tried that one first.  It didn't work, so I tried the other posts.
0
 
J.R. SitmanIT DirectorAuthor Commented:
@capricorn1, when I place the cursor in the field, it doesn't do anything and it will let me enter any date format I want.
0
 
Gustav BrockCIOCommented:
I don't think that is possible, because the characters of the mask determine the type of allowed characters, not the character(s) to input. Like the example:

>L????L?000L0   to allow for input like: GREENGR339M3

/gustav
0
 
J.R. SitmanIT DirectorAuthor Commented:
@cactus_data.  Thanks.  Not that important anyway
0
 
Rey Obrero (Capricorn1)Commented:
what version of access are you using?
0
 
J.R. SitmanIT DirectorAuthor Commented:
2010, backend is 2003 format
0
 
J.R. SitmanIT DirectorAuthor Commented:
Thanks
0
 
Gustav BrockCIOCommented:
You are welcome!

/gustav
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.