Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    311

    Unanswered: inserting Date and time into a report from the menu

    I used the menu (insert, Date and time) to create a txt box with the following formula:

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

    But now when i run this report i am being Prompted for Format and then prompted for the Date. Has anyone else experianced this?


    I logged on to the same db from a diff computer and i dont get the prompts,, hmmmm this is truely odd, and worst I HAVE TO FIX The date and time to display


    PLS Help

    M~

  2. #2
    Join Date
    Oct 2003
    Location
    New York
    Posts
    23

    Re: inserting Date and time into a report from the menu

    Well, I couldn't recreate your problem...you can always just input "=Now()" into your unbound text box...it will produce the date and time...date will be mm/dd/yyyy and your time will be long...

    You can also try the following date format:

    Format(Date(),"dddd"", ""mmmm"", ""d"", ""yyyy")

    Maybe that will help...

  3. #3
    Join Date
    Oct 2003
    Posts
    311
    Now() works ,, Crzy Access )

Posting Permissions

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