Null values in report

  • Thread starter Thread starter GordonDow
  • Start date Start date
G

GordonDow

I have a question I hope you can answer. I have produced a invoic
report which incorporated the customers names and addresses. Howeve
some of the data in the field on the table are empty and this of cours
is coming out as a blank line in my report

The fields I have at present read like this:-

=[First name]& " " & [Last name] (John Smith)
Address 1 (1 Anyway)
Address 2
Address 3
Town (Biggtown)
Postal code (AB1 2CD)

How do I stop the blank spaces appearing, when I have records lik
this.

I hope you can hel
 
Steve Schapel answered your previous post of the same question:

"Set the Can Shrink property of the controls in question to Yes, and also
the CanShrink property of the report section itself. This will work as
long as you don't have any other controls on the report on the same
horizontal level as the Null control."
 
Back
Top