Suppress field on report

  • Thread starter Thread starter Asha
  • Start date Start date
A

Asha

I have a field on a report that is a text field that
defaults to a NULL value. I want to be able to suppress
the field (or printing of the field) if the field contains
a null value. The reason I want to do this is because
there will be several of these fields with NULL values.
If I don't suppress them then they take up a lot of space
on the report. If I can suppress them when they are not
being used then I will have a better looking report.

Thank you.
 
right click on control > Properties
The Can Grow and Can Shrink properties don't always behave as expected.
Particularly, if there are other controls at the same level to the left or
right of the control then Access cannot shrink or grow the control.

To overcome this, you could consider concatenating these values into a text
field.
For example, rather than having two controls for Address1 and Address2
you could have one control for address that has a control source =[Address1]
& vbcrlf + [Address2]

Notice the use of the & and + operators that takes advantage of Null
propagation.

HS
 
Back
Top