R
RNUSZ@OKDPS
I have a MsWord file FR11.doc that I would like to use as a form letter to
be loaded with select data from Microsoft Access 2003 database via Access
User Form and query of data selection.
The mail merge is working fine, the form letter gets each field properly
loaded and allows for "JUSTIFIED" margin control for both left & right
printline margins (something that the Microsoft Access Report capability does
not provide).
My problem is there are dates in the record that contain the data formatted
as: 12091992 for December 9, 1992. My statement in the form letter is as
follows:
Now on this day, <<hrgDate>>, the above entitled cause comes on for
hearing before the undersigned Hearing Officer; the Licensee and all
interested parties having been given an opportunity to offer evidence and
present argument and upon consideration thereof the undersigned Hearing
Officer finds:
When the hearing date (12091992) gets stuffed into the form the output is
printed as:
Now on this day, 12/9/1992, the above entitled cause comes on for
hearing.....
and what I want to do is to reformat the date format to print out as...
Now on this day, 9 December, 1992, the above entitled cause comes on
for hearing.....
Can this be accomplished? If so, has anyone an idea of how to properly
format this via Microsoft Word and Mail Merge function....
When I use Microsoft Access and its built in report building I use the
following code:
Now on this day, " & Format([HRG_DATE],"dd mmmm"", ""yyyy") & ", the above
entitled cause comes on for hearing.....
I've attempted to use the same code via the MsWord.doc file, it does not
give me a syntactical error, but still prints as 12/9/1992 instead of 9
December, 1992. Can someone advise....
Thanks in advance.
be loaded with select data from Microsoft Access 2003 database via Access
User Form and query of data selection.
The mail merge is working fine, the form letter gets each field properly
loaded and allows for "JUSTIFIED" margin control for both left & right
printline margins (something that the Microsoft Access Report capability does
not provide).
My problem is there are dates in the record that contain the data formatted
as: 12091992 for December 9, 1992. My statement in the form letter is as
follows:
Now on this day, <<hrgDate>>, the above entitled cause comes on for
hearing before the undersigned Hearing Officer; the Licensee and all
interested parties having been given an opportunity to offer evidence and
present argument and upon consideration thereof the undersigned Hearing
Officer finds:
When the hearing date (12091992) gets stuffed into the form the output is
printed as:
Now on this day, 12/9/1992, the above entitled cause comes on for
hearing.....
and what I want to do is to reformat the date format to print out as...
Now on this day, 9 December, 1992, the above entitled cause comes on
for hearing.....
Can this be accomplished? If so, has anyone an idea of how to properly
format this via Microsoft Word and Mail Merge function....
When I use Microsoft Access and its built in report building I use the
following code:
Now on this day, " & Format([HRG_DATE],"dd mmmm"", ""yyyy") & ", the above
entitled cause comes on for hearing.....
I've attempted to use the same code via the MsWord.doc file, it does not
give me a syntactical error, but still prints as 12/9/1992 instead of 9
December, 1992. Can someone advise....
Thanks in advance.