Invisible field and shrinking report

[John]

Hi

In OnFormat I am making a field invisible or visible based on its value. The
problem is that when the field is invisible it leave a blank line on the
report. Is there a way to shrink the report if the field is invisible?

Thanks

Regards

 

[Allen Browne]

Instead of changing its Visible property, use an IIf() expression to
substitute Null for the cases where you don't want to show anything. You can
then use its Can Shrink property, and any controls below it will move up to
take its place.

Example: if you want to hide the NumberOfPregnancies field when Gender =
"M", use:
=IIf([Gender]="M", Null, [NumberOfPregnancies])