Access 2003: Make a combo box value equal todays date

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bknabl
    New Member
    • May 2010
    • 19

    Access 2003: Make a combo box value equal todays date

    I tried setting up a new combo box to have todays date as a user choice by setting its property to a value list. Then for the row source it set it to =Date(). Access will not show what the expression equals but only the expresion formula itself. What am I doing wrong here? Thanks in advance!
  • bknabl
    New Member
    • May 2010
    • 19

    #2
    I figured out another way to get around this by entering todays date on an afterevent is called.

    Comment

    • Jerry Maiapu
      Contributor
      • Feb 2010
      • 259

      #3
      You should have also put
      Code:
      =Date()
      as default value ..
      This way you can have the chance of editing/changing

      Comment

      • NeoPa
        Recognized Expert Moderator MVP
        • Oct 2006
        • 32661

        #4
        If you have a ComboBox that includes today's date as a value, then all you need do to select this value is set the value of the ComboBox to today's date :
        Code:
        Me.cboDates = Date()
        Where you put this depends on what exactly you're after, but the Form_Open() event procedure works for most cases.

        Comment

        Working...