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
 
Back
Top