![]() |
|
#1
|
||||
|
||||
![]()
Since the user is running Access 2002 on Windows XP, it's quite likely they're also using Word 2002.
I suspect the issue is that the Access data default's to today's date when blank. If today's date is never valid, you could use an IF field to suppress it: {IF{MERGEFIELD Report_Date \@ "dd/MM/yyyy"} <> {DATE \@ "dd/MM/yyyy"} {MERGEFIELD Report_Date \@ "dd/MM/yyyy"}} Note: The field brace pairs (ie '{ }') for the above example are created in the body of the document via Ctrl-F9 (Cmd-F9 on a Mac) - you can't simply type them or copy & paste them from this message.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#2
|
|||
|
|||
![]()
The blank date fields are blank in the Access table rather than being populated with today's date, so I'm not sure it's Access rather than the mail merge that's doing it. BUT I'll try that switch.
Is there a way to put 0 (zero) or null into the switch ? |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
redzan | Mail Merge | 1 | 05-16-2013 08:34 AM |
![]() |
Erbwon | Word | 6 | 11-12-2012 06:17 PM |
Please help me with creating due date field | Artemio | Word | 1 | 03-01-2012 08:10 PM |
![]() |
borntorun75 | Mail Merge | 3 | 12-16-2011 06:28 AM |
Formula to subtract one month from due date field in reminder field | ghumdinger | Outlook | 1 | 10-01-2011 12:09 AM |