Results 1 to 5 of 5

Thread: date field

  1. #1
    Join Date
    Oct 2008
    Posts
    33

    Unanswered: date field

    hi all,
    i there a way to let the date field display the format in which the date should be entered. example instead of showing _/_/__, can it actually show DD/MM/YYYY, to make it easier for the user? any help would be appreciated.
    thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    look at applying a format mask to the input control
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Oct 2008
    Posts
    33
    thanks for the advice but how exactly to i go about doing this. i have tried so many things but i cant seem to figure it out. some guidance would be appreciated if possible.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    The request is incorrect imo.

    Since a user can enter a date as:

    1st July 2009
    1/7
    1 Jul
    1/7/09
    1-7

    and a whole host of others, all of which mean the same thing, 1st July in the current year, who cares in what format the data is accepted?! You shouldn't! If you force users to enter in 01072009 then you are making it user UN-friendly.

    Try not to impose so much control over the user, rather, let the user have the freedom to do things their way as much as possible.

    My 2¢.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by wild kayode
    thanks for the advice but how exactly to i go about doing this. i have tried so many things but i cant seem to figure it out. some guidance would be appreciated if possible.
    open the form in design mode
    select the desired control
    right click to view peoperties, or if the properties box is visibile already look at the properties
    select the correct property (IIRC its called format mask)
    press the help key (f1) for further information
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •