locked
input mask date and time RRS feed

  • Question

  • Hello can someone help me I notice you can edit the Input Mask in access is there a way to edit the list to where the user has to put in

    10/9/2014 4:30:00 PM

    in that format???
    Wednesday, October 29, 2014 9:04 PM

Answers

  • Hello can someone help me I notice you can edit the Input Mask in access is there a way to edit the list to where the user has to put in

    10/9/2014 4:30:00 PM

    in that format???

    You can accomplish to change your Input Mask like this: 

    99/99/0000\ 09:00:00\ >LL;0;_

    Hope this helps,


    Daniel van den Berg | Washington, USA | "Anticipate the difficult by managing the easy"

    Please vote an answer helpful if they helped. Please mark an answer(s) as an answer when your question is being answered.

    Wednesday, October 29, 2014 9:55 PM

All replies

  • Hello can someone help me I notice you can edit the Input Mask in access is there a way to edit the list to where the user has to put in

    10/9/2014 4:30:00 PM

    in that format???
    If the field of the table is a DateTime field thenit doesn't matter what format the data is entered as long as Access can recognize it as a date.

    Build a little, test a little

    Wednesday, October 29, 2014 9:15 PM
  • Hello can someone help me I notice you can edit the Input Mask in access is there a way to edit the list to where the user has to put in

    10/9/2014 4:30:00 PM

    in that format???

    You can accomplish to change your Input Mask like this: 

    99/99/0000\ 09:00:00\ >LL;0;_

    Hope this helps,


    Daniel van den Berg | Washington, USA | "Anticipate the difficult by managing the easy"

    Please vote an answer helpful if they helped. Please mark an answer(s) as an answer when your question is being answered.

    Wednesday, October 29, 2014 9:55 PM
  • thank you so much that's exactly what I needed
    Thursday, October 30, 2014 12:22 AM