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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Use an IIF statement like this --
IIF([YourField] Is Null, Space(50), [YourField])

Replace the 50 with your required number of spaces.
 
Where do I enter this in Office 2003?

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

Replace the 50 with your required number of spaces.

wboes said:
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?
Click to expand...
Click to expand...
 
Enter it in the query you use for data source for the merge instead of using
the table directly.

wboes said:
Where do I enter this in Office 2003?

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

Replace the 50 with your required number of spaces.

wboes said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top