May 24, 2006 #1 TStoker Programmer Joined May 24, 2006 Messages 1 Location US I have a report that I want to hide several data fields if the user selects TRUE from a parameter. How do I do this? ps I don't want to just make the font white because people will be able to export and could see the data if they know it exists in the report.
I have a report that I want to hide several data fields if the user selects TRUE from a parameter. How do I do this? ps I don't want to just make the font white because people will be able to export and could see the data if they know it exists in the report.
May 30, 2006 #2 milton747 Programmer Joined Apr 21, 2005 Messages 133 Location US In OnRow() of the control, test param and do: IF ParamValue IS True THEN DataValue = "" END IF Upvote 0 Downvote