Help with Visible Property in Reports

[EBox]

Using a report that references a Date field [Date], and Text fields [C1],[C2], and [C3], I am trying to set up the report so that [C2] and [C3] are not visible when Format([Date],"ddd&quot In ("Sun","Sat&quot, but I'm having trouble using the Visible property to do this. Anyone have any suggestions?

Also, as an extension of this- for the form entry into this table, is there a similar way to make [C2] and [C3] form fields not appear for the same criteria?

Thanks,
EBox

 

[DancingDon]

In the OnFormat, enter code that says if Format([Date],"ddd&quot = "Sun" or Format([Date],"ddd&quot = "Sun","Sat" then the visible properties of C1, C2 etc = No else the visible properties of C1, C2 etc = Yes

DancingDon