Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppressing details

Status
Not open for further replies.

charbaugh

Programmer
Jan 12, 2005
4
US
If a certain field is blank then suppress the row, how would I do this on the details section?

If {ado.City} = " " Then
SuppressRow(???)
End If

 
1) Go into the selection expert of the detail section
2) Click on the 'X2' button to the right of surpress
3) Enter in '{ado.City} = " "' or isnull({ado.City})

That's it.
 
that worked, now I want to suppress the column names in the group header if there are no details

how doo?

thanks again
 
I would create a sum for the group, then if that sum is equal to zero, surpress the group header.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top