Reports - empty fields

  • Thread starter Thread starter Zara Henessy
  • Start date Start date
Z

Zara Henessy

Sorry my last post wasn't very clear.

I am creating a report from a single table of address and
contact information.

For some records a few fields are empty. Is there a way
to supress the empty fields in the report? So that the
report doesn't leave a blank space / row, thereby looking
neater and saving paper when I have to print the report
out.

I am not using field labels, just the output of the
fields in the reports.

i.e. Ideally, as in the below example the report skips
the third field (city) for record two as it did not
contain any data.


record 1

Mr A Smith
100 Lakeside Drive
London
555 - 15555
777 - 17777

record 2

Mr J Jones
44 Riverdale Street
444 - 1444
888 - 1888

I really appreciate your help.

Zara
 
Set the Can Shrink property of the text boxes to Yes. This will work as long
as the values a null and there are not controls to the left or right of the
"can shrink" text boxes.
 
In the query for the report

find the fields where there a blank (or NULL) values.

Then in the criteria for those fields put

Is Not Null

the query will then filter out the records with NULL
values for that field.
 
Back
Top