Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-29-2013, 06:43 PM
macropod's Avatar
macropod macropod is offline Date field inserting merge date in blank field Windows 7 32bit Date field inserting merge date in blank field Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #2  
Old 09-29-2013, 11:58 PM
Lesley Lesley is offline Date field inserting merge date in blank field Windows 7 64bit Date field inserting merge date in blank field Office 2010 32bit
Novice
Date field inserting merge date in blank field
 
Join Date: Sep 2013
Posts: 4
Lesley is on a distinguished road
Default

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 ?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Date field inserting merge date in blank field How to ignore a mail merge field if the field is blank redzan Mail Merge 1 05-16-2013 08:34 AM
Date field inserting merge date in blank field Date Field to add 10 Days to Current Date 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
Date field inserting merge date in blank field Mail merge will not format date field generated by Excel IF statement 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:45 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft