Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jul 2003
    Location
    Cincinnati, Ohio
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a text box on a form that uses the following epxression to pull dates from text box controls on another form:
    ="Activity Statistics for Date Range:" & Forms!frmDateRangeForActivity!Text12 & " - " & Forms!frmDateRangeForActivity!Text14
    Which results in : Activity Statistics for Date Range:7/6/2009 4:31:16 PM - 7/25/2009 4:31:16 PM
    How/where can I apply short date formatting to the control source for this control?
    Thank you very much.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    By using the Format function in the expression:

    ="Activity Statistics for Date Range:" & Format(Forms!frmDateRangeForActivity!Text12, "mm/dd/yy") & " - " & Format(Forms!frmDateRangeForActivity!Text14, "mm/dd/yy")

    You can specify another date format of course.

  3. #3
    2 Star Lounger
    Join Date
    Jul 2003
    Location
    Cincinnati, Ohio
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you Hans!

    [quote name='HansV' post='786294' date='26-Jul-2009 13:32']By using the Format function in the expression:

    ="Activity Statistics for Date Range:" & Format(Forms!frmDateRangeForActivity!Text12, "mm/dd/yy") & " - " & Format(Forms!frmDateRangeForActivity!Text14, "mm/dd/yy")

    You can specify another date format of course.[/quote]

Posting Permissions

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