How to hide data on my report

[access_db_user]

Hi All,

A previous developer has created a report within an MS Access database and the new requirement is to hide the data/rows from the report if the field has a value of 100%.


The value for this field is coming from a column within a SQL server table.

The name of this column is "Percentage" and the Data tab in the Property Sheet has Control Source = Percentage

Can anyone help me in the formula to suppress the 100% in case Percentage = 100?

Thanks!

[Micron]

The report should be based on a query, not the table itself, for this very type of reason. Your query would limit the records returned where the Percentage is less than 100. AFAIK, percentage is not a problem/reserved word, but I would not use percent. Suggest you replicate the table fields you need with a query. Note: you would not be hiding the rows - you would not be bringing them back. If hiding is what you MUST do, I'm not sure that's possible, even if using code for the report format section On_Format event or format.property.

[June7]

As Micron points out, records are filtered, not 'hidden'. Hiding rows is an Excel feature.

[access_db_user]

Hi Guys,

Thank you for the response, Actually i had misstated my problem earlier and the report source is in-fact a query within a SQL server database. I was able to filter out all the values that had 100% by using a Where clause in the Record source.

Thanks again!