Conditional Visible Header

  • Thread starter Conditional Visible Header
  • Start date
C

Conditional Visible Header

I have a report that has a header called cdccost. The cdccost header has a
field within the header that displays cost (Cost) and another field that
indicates what type of cost it is "cdc cost" or "flat cost". I want the
header to be visible only when the "cdcind" field is equal to "cdc cost".
Else I want it to be hidden. In other words, I only want the header to show
when there is information in the fields within the header.
 
W

Wayne-I-M

Hi

You could insert an unbound text box into the field head and use this as the
source

=IIf ( [tableName]![cdcind] ="cdc cost", ]![cdcind])

I assume that there are a number of options cdc cost, flat cost, etc. so
just setting the can shrink would not work as there may be other text in the
field.


Then set the can shrink and can grow = yes for both the field and the header
section. Set the field cdcind to visible = no

Change the table name to whatever it is

This would seem the simplelist method but there are other like settting the
field contact from the query, etc.
 
Top