Results 1 to 4 of 4

Thread: show date

  1. #1
    Join Date
    Nov 2004
    Posts
    7

    Unanswered: show date

    dose anybody know the code to put in the date feild to show the todays date wen the form is running

    thanks

  2. #2
    Join Date
    Sep 2004
    Posts
    112
    1, Just create a text box on your form.
    2, In the propertys of the text box click the data tab.
    3, In the control source just type =Format(Date)
    Depending how you want the date to be formatted add ,"Long Date") to the end
    ie: =Format(date), "Long Date")
    the result would be 16 November 2004

    Hope that helps.

    Saltman

  3. #3
    Join Date
    Sep 2004
    Posts
    112
    Sorry! slight syntax error should read: = Format(Date(), "Long Date")

    Saltman.

  4. #4
    Join Date
    Dec 2004
    Posts
    4

    Add Time

    Add the time, too!

    =Format(Date(),"Long Date") & " " & Format(Time(),"Long Time")

Posting Permissions

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