Null Fields in a report

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

I am creating an address book database and would like to
use two address lines. Is is possible to avoid the blank
line in the report if the field is empty?
 
Just be sure that the value is null too...an empty value ("") won't shrink
the field..

IIF(report![Field]="",Null,report![Field])

-David
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A ZLS being reported as null 9
How do I suppress blank lines in reports 1
Blank Lines 1
Fields not shrinking 5
Null fields in a calculated field 5
Empty fields in report 4
Prevent report from running if a field is null 2
Canshrink question!! 2

Back
Top