• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1743
  • Last Modified:

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
0
J.R. Sitman
Asked:
J.R. Sitman
  • 7
  • 4
  • 4
1 Solution
 
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
 
J.R. SitmanAuthor 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
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
Rey Obrero (Capricorn1)Commented:
upload a copy of your db
0
 
Gustav BrockCIOCommented:
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
 
J.R. SitmanAuthor 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. SitmanAuthor Commented:
@capricorn1, yes sir I did.  I tried that one first.  It didn't work, so I tried the other posts.
0
 
J.R. SitmanAuthor 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. SitmanAuthor Commented:
@cactus_data.  Thanks.  Not that important anyway
0
 
Rey Obrero (Capricorn1)Commented:
what version of access are you using?
0
 
J.R. SitmanAuthor Commented:
2010, backend is 2003 format
0
 
J.R. SitmanAuthor Commented:
Thanks
0
 
Gustav BrockCIOCommented:
You are welcome!

/gustav
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 7
  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now