Results 1 to 4 of 4

Thread: Format()

  1. #1
    Join Date
    Sep 2004
    Posts
    17

    Unanswered: Format()

    Anyone see a problem with this:

    ="Printed on: " & Format(Now(),"m/d/yyyy")


    When the report is run, an input box pops up asking for Format. It worked fine yesterday. And nothing was changed.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    try
    ="Printed on: " & Format(Now(),"mm/dd/yyyy") 'for 03/02/2005
    ="Printed on: " & Format(Now(),"mmm/dd/yyyy") 'for March/02/2005

  3. #3
    Join Date
    Sep 2004
    Posts
    17
    yes, but what ever I have "m/d/yyyy" or "mm/dd/yyyy" or "mmmm/dd/yyyy", it still asks for the input of Format.

  4. #4
    Join Date
    Aug 2002
    Location
    Northampton, England
    Posts
    266
    Add another text box for the "Printed on:"

Posting Permissions

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