Results 1 to 1 of 1
  1. #1
    drmsktchr is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2013
    Posts
    9

    Formating the Date into Word as a specific format

    UPDATE: I got my date function to return the way it should, so I am fine with the date.

    I was able to get the date to work by using the following line:



    Code:
     .Selection.Text = Format(Forms!WebBasedIFV!reportDateText, "mmmm dd, yyyy")
    I am working on automating a report from Access 2007 to Word 2007. I have everything pretty much working, but having to update some minor things.
    I am having issues with being able to format the date to a particular way once the information is passed to Word.

    Here is the code I have for the date (I am trying to have the date formatted to January 1, 2013 format)
    Code:
    'Move to each bookmark and insert the text from the form
    .ActiveDocument.Bookmarks("reportDate").Select
    .Selection.Text = (CStr(Forms!WebBasedIFV!reportDateText.Format = "mmmm dd, yyyy"))
      'reapply the bookmark name to the selection
      .ActiveDocument.Booksmarks.Add Name:="reportDate", Range:=Selection.Range
    Anyone who can assist would be extremely appreciative.
    Last edited by drmsktchr; 02-12-2013 at 11:36 AM. Reason: was able to resolve

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

Similar Threads

  1. Replies: 5
    Last Post: 12-17-2012, 11:54 AM
  2. formating hours and minutes to 0.00 format
    By live2ride in forum Access
    Replies: 17
    Last Post: 09-18-2012, 07:52 PM
  3. Replies: 1
    Last Post: 06-15-2012, 05:51 PM
  4. Split string when specific word is found
    By DB4284 in forum Programming
    Replies: 1
    Last Post: 11-18-2010, 03:30 PM
  5. Replies: 1
    Last Post: 07-27-2010, 07:06 AM

Tags for this Thread

Posting Permissions

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