Results 1 to 4 of 4

Format Unbound Text Box to Display Medium Date Format

  1. #1
    elhale is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Sep 2016
    Posts
    13

    Format Unbound Text Box to Display Medium Date Format

    I have a report I produce from my DB that includes two unbound text boxes used to show dates (a Start and an End date) in the title of the report. The dates are pulled from a Date Entry form used by the user to select the date range of the report. Currently the report works fine and the dates show up in the title of the report just as expected. What I would like to do now is format the dates into a medium date format. (i.e., December 14, 2016 as opposed to the current short format, i.e., 12/4/2016) Can anyone help me with how to format the textbox so the date will display as a medium date format? Thanks

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    5,356
    Put the header in the report query,then you can format it at will....
    Header: format(forms!myForm!txtStart,"mmmm dd,yyyy") & " to " & format(forms!myForm!txtEnd,"mmmm dd,yyyy")

    then the report just pints to this field.

  3. #3
    ssanfu is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    6,752
    Open the report in design view.
    Click on the date text box.
    Open the property dialog box. (double click on the outside line)
    Click on the FORMAT tab.
    Set the Format property to the date format you want. (medium date)
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

  4. #4
    elhale is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Sep 2016
    Posts
    13
    ranman and ssanfu, Thank you both! I appreciate your help. Looks like using the Format property worked perfectly! Thanks again!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 06-15-2016, 12:32 PM
  2. Date Format Display
    By drunkenneo in forum Access
    Replies: 5
    Last Post: 06-20-2013, 06:06 AM
  3. Replies: 4
    Last Post: 03-12-2013, 05:49 PM
  4. format text string as date
    By rbrem in forum Access
    Replies: 2
    Last Post: 08-28-2012, 07:39 AM
  5. Date Entry in one format display in another
    By mikethebass in forum Forms
    Replies: 1
    Last Post: 01-22-2012, 04:34 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums