Suppress Field

  • Thread starter Thread starter Dorothy
  • Start date Start date
D

Dorothy

In a report I have a field 'DateSent' and another
field 'Status' I only want the DateSent field to show for
those records where the Status is = to Approved. How do I
go about doing this?
 
Either use conditional formatting, or create an unbound field. In the
unbound field, enter a statement like...

=IIf([Status]="Approved",[DateSent],"")


Rick B




In a report I have a field 'DateSent' and another
field 'Status' I only want the DateSent field to show for
those records where the Status is = to Approved. How do I
go about doing this?
 
1. Open your report in design view.

2. Right-click the DateSent text box, and choose Propeties.

3. On the Data tab of the Properties box, change the Control Source property
to:
=IIf([Status]="Approved", [DateSent], Null)

4. On the Other tab of the Properties box, change the Name property to:
txtDateSentApproved
You can use any name, but it cannot be DateSent because that is a field
name.

5. On the Format tab of the Propeties box, set the Format property to:
Short Date
or whatever date format you want.
 
Back
Top