Merge form Access 07 to Word 07

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roberto - 28 Apr 2008 15:02 GMT

I have a text field data in Access 2007 in this input mask format: "07-08"
(99-99;0;_), when merge this field in Word 2007 this format disappear and
display this format: "0708" without the hyphen (-).
I appreciate some help.
Tanks.

Reply to this Message

Doug Robbins - Word MVP - 28 Apr 2008 20:28 GMT

Probably better to use the Format function in a query in Excel and use that
as the data source, but in Word, use Alt+F9 to toggle on the display of the
field codes in the mail merge main document and add the following formatting
switch inside the closing }

\# "00'-'00"

Use Alt+F9 again to toggle off the display of the field codes.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have a text field data in Access 2007 in this input mask format: "07-08"
> (99-99;0;_), when merge this field in Word 2007 this format disappear and
> display this format: "0708" without the hyphen (-).
> I appreciate some help.
> Tanks.

Reply to this Message

Roberto - 29 Apr 2008 18:53 GMT

Thank you, Doug Robbins.
This option works very well.

> Probably better to use the Format function in a query in Excel and use that
> as the data source, but in Word, use Alt+F9 to toggle on the display of the
[quoted text clipped - 10 lines]
> > I appreciate some help.
> > Tanks.

Reply to this Message

Rate this thread: