How do I leave a field blank when merging a document with Access?

's Computer Specifications

Sometimes I leave a field blank in my database because I don't have the
information at that time. When mail merging with a Word document, I want to
leave that field blank in the document so I can fill it in by hand. How do I
do this?

's Computer Specifications

Use an IIF statement like this --
IIF([YourField] Is Null, Space(50), [YourField])

Replace the 50 with your required number of spaces.

"wboes" wrote:

> Sometimes I leave a field blank in my database because I don't have the
> information at that time. When mail merging with a Word document, I want to
> leave that field blank in the document so I can fill it in by hand. How do I
> do this?

's Computer Specifications

Where do I enter this in Office 2003?

"KARL DEWEY" wrote:

> Use an IIF statement like this --
> IIF([YourField] Is Null, Space(50), [YourField])
>
> Replace the 50 with your required number of spaces.
>
> "wboes" wrote:
>
> > Sometimes I leave a field blank in my database because I don't have the
> > information at that time. When mail merging with a Word document, I want to
> > leave that field blank in the document so I can fill it in by hand. How do I
> > do this?

's Computer Specifications

Enter it in the query you use for data source for the merge instead of using
the table directly.

"wboes" wrote:

> Where do I enter this in Office 2003?
>
> "KARL DEWEY" wrote:
>
> > Use an IIF statement like this --
> > IIF([YourField] Is Null, Space(50), [YourField])
> >
> > Replace the 50 with your required number of spaces.
> >
> > "wboes" wrote:
> >
> > > Sometimes I leave a field blank in my database because I don't have the
> > > information at that time. When mail merging with a Word document, I want to
> > > leave that field blank in the document so I can fill it in by hand. How do I
> > > do this?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How eliminate autofill of USA in country field -- leave blank	Squirrel	Microsoft Outlook Contacts	1	13th Feb 2009 10:19 PM
How do you leave a blank space in drop down field?	=?Utf-8?B?QW5naWU=?=	Microsoft Word Document Management	2	20th Oct 2007 06:14 AM
Check box form field merging to a new document	=?Utf-8?B?cmx0ZzIwMDM=?=	Microsoft Word Document Management	1	10th May 2007 08:34 PM
Paper Report... leave field blank if already filled in	jake	Microsoft Access Reports	1	4th May 2005 05:45 AM
How to leave POP3 field blank	Ed B.	Microsoft Outlook Discussion	3	18th Oct 2004 07:09 PM