Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Kankakee, Illinois, USA
    Thanked 0 Times in 0 Posts

    Formatting Medium Time (Access 2000)

    When I create a text box combining two control sources, I am having trouble forcing the result to abide by my chosen format. I have two items that when listed alone, show the medium time - 8:00 am. However, when I combine two times, I want it to appear as: 8:00 am - 10:00am. Unfortunately, it appears as: 8:00:00am - 10:00:00am. Everywhere I look, it says the format is Medium Time. How do I force the combined control sources to appear correctly? This is the formula I am using to combine the two sources: =[Provider Start]&" - "&[Provider End] Please help, and Thank you.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Formatting Medium Time (Access 2000)

    If you concatenate expressions, the Format property of the text box has no effect on the dates any more, because the result of the concatenation is a text string, not a date. You will have to put the formatting into the expression:

    =Format([Provider Start], "Medium Time") & " - " & Format([Provider End], "Medium 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