Invisible field and shrinking report

  • Thread starter Thread starter John
  • Start date Start date
J

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
 
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])
 
Back
Top