Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Extracting Date Parts (2000)

    Hi, I have two synchronised combos on a form that are used to find record(s). One is the name of a person and the second a date in form of dd/mm/yy, this comes from a date from entries in the underlying table. From a "look" point I want the combo just to show mm/yy, is this possible?

    Cheers Darren.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Extracting Date Parts (2000)

    If you want the text box part of the combo box to display the date in mm/yy format, set the Format property of the combo box to mm/yy. If you want the list part to display the dates that way too, you should change the row source of the combo box to a query that returns the dates formatted as mm/yy.

  3. #3
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Extracting Date Parts (2000)

    Thanks again Hans.

    Darren.

Posting Permissions

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