Autofill current date in field on form

Ask a Question related to Microsoft Access, Design and Development.

  1. #1

    Default Autofill current date in field on form

    Need a field to autofill the current date on a form. The
    user will be filling in one field with a control number
    and the date field will be the current date. Cant't get
    it to autofill with the current date.
    LLR Guest

  2. Similar Questions and Discussions

    1. Get current date/time? Use them in hidden field?
      I've got an app that works as a reception log for clients coming in our agency. The receptionist logs each client's name into our log database. ...
    2. Autofill date field
      I have been trying to get a Date field filled automatically whenever the form I created in Mac Acrobat 7 is opened. I have defined the field as a...
    3. adding current date into Access using DW form
      I've looked all over this forum finding similar solutions but not exactly what I'm looking for. Relatively simple. My Access 2002 database has a...
    4. date & time in form field
      I want to put the current date and time into a form field which will them be submitted to a database. Is this possible? If so, what code should I...
    5. Autofill text field with stored db results?
      Currently, Im using a populated select box containing a list of customers. I would like to instead have a textbox in which the user would type in...
  3. #2

    Default RE: Autofill current date in field on form

    Set the default value to date()

    Ex: =(Date)
    - - Dean
    >-----Original Message-----
    >Need a field to autofill the current date on a form.
    The
    >user will be filling in one field with a control number
    >and the date field will be the current date. Cant't get
    >it to autofill with the current date.
    >.
    >
    Dean Guest

  4. #3

    Default Re: Autofill current date in field on form

    : Need a field to autofill the current date on a form. The
    : user will be filling in one field with a control number
    : and the date field will be the current date. Cant't get
    : it to autofill with the current date.

    I am assuming that this form is data entry only, and the
    form is not being used to edit existing records. I am using
    the field name of Control_Number for what the user enters &
    Date_Entered for the date, format as short date. I would
    use something similiar to this:

    Private Sub Control_Number_Exit(Cancel As Integer)
    Date_Entered = Format(Now, "mm/dd/yyyy")
    End Sub


    Mike Mueller Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139