Seldom used field showing on reports

A

ag

I have an Access database with fields that will in all likelihood remain null
.... but on the off chance that something does make it into these fields I
want this to show on a report. How do I make it that if a field is not null
that the contents are visible on the report and if the field is null then it
doesn't show as white space in my report ...
 
J

Jeff Boyce

Open the report in design mode.

Add a control to display that field.

Change the control's CanGrow and CanShrink properties to Yes.

Change the CanGrow and CanShrink properties of the SECTION in which the
control is placed to Yes.

DON'T put any other controls directly aligned to left or right.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top