Conditional REMOVAL

[Randomblink]

I have a report...the table it is based on has over 100 different fields full of data PER EACH RECORD...ugh!
Well, I am designing my report, and as I go I want sections of fields to disappear based on ONE SPECIFIC field...

If the record being viewed is a CITY project, I want all the CITY-SPECIFIC fields to appear and all the CONTRACT-SPECIFIC fields to disappear...and vice versa...

However, without writing HUGE amounts of codes for a simple Select Case, surely there is a way to refer to a group of fields in code...can someone help me?

 

[PhilE]

Try putting the field to be tested (City?) in a section of it's own, then use the on format event of the section to hide or show other fields/sections...

 

[Randomblink]

Put it in a section of it's own?
Do you mean under grouping/sorting...?
If I create a group I have to name it...
If I name it, it is considered an expression, and therefore needs to be filled with a variable...
OR
If I don't name it but assign it to a variable, then the report will sort by that variable...and I don't want that...
HELP!?