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."
 
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

Blank lines in reports 1
Null Values in reports 4
SynNeed to account for null values in subreports 2
A ZLS being reported as null 9
Empty fields in report 4
Blank lines in report 1
Prevent report from running if a field is null 2
Fields containing null values... 2

Back
Top