Ignore header without information

drfever

New member
Local time
Today, 03:39
Joined
Nov 20, 2002
Messages
5
I would like to have three headers, first-manufactuer and second -size and third - color.

I want the manufactuers to be grouped together regardless if color is blank. Currently, I have two groupings for each manuf. One with color and the other blank.

How can I have my report ignore the color header when entries are blank and group them under the same size header and separate them when color is available?
 
If IsNull(Me.MyField) Then
Me.Section(Whatever).Visible=False
Else
Me.Section(Whatever).Visible=True
End If
 

Users who are viewing this thread

Back
Top Bottom