Results 1 to 3 of 3

Thread: AM/PM in time

  1. #1
    Join Date
    Jul 2006
    Posts
    157

    Unanswered: AM/PM in time

    Hi:
    Can any one pleaset tell me how to i add AM and PM with that line. So that according to the time it will be shows AM or PM.

    Me.lblTime.Caption = Format(Now(), "HH:NNS")

    Thank You.

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Format(Now(), "HH:NN:ampm")
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Actually
    Code:
    Format(Now(), "HH:NN:ampm")
    will give you 11:27:AM while

    Code:
    Format(Now(), "HH:NN ampm")
    will give you a better looking 11:27 AM
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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