Turning off a detail line in a Report

[Lilbrat]

Is there anyway to turn off a Footer line in a report?

I have "Descriptio n Header" and "Descriptio n Footer". "Descriptio n Header" holds most of the information while "Descriptio n Footer" Holds one field called "Notes". If "Notes" is empty, I don't want "Descriptio n Footer" to print.

I have tried using If statements under the Format event and a couple of the other events but have had no luck. Am I trying something that can't be done?

[Rabbit]

You might have to mess around with which format event to use but you can set the visibility of a section to True/False to hide them.

[Jim Doherty]

Is there anyway to turn off a Footer line in a report?

I have "Descriptio n Header" and "Descriptio n Footer". "Descriptio n Header" holds most of the information while "Descriptio n Footer" Holds one field called "Notes". If "Notes" is empty, I don't want "Descriptio n Footer" to print.

I have tried using If statements under the Format event and a couple of the other events but have had no luck. Am I trying something that can't be done?

How about simply setting the notes textbox to zero height dragging up the footer to match the zero height of the textbox and then set the 'Can Grow' property of the textbox to Yes that way the footer expands or contracts depending whether or not something is in the field

Regards

Jim

[Lilbrat]

How about simply setting the notes textbox to zero height dragging up the footer to match the zero height of the textbox and then set the 'Can Grow' property of the textbox to Yes that way the footer expands or contracts depending whether or not something is in the field

Regards

Jim

Wow... I spent all that time messing with Format and VBA and it was that simple? :) Thanks alot :)