Conditionally Displaying Information On a Report

[mmelady]

Hello everyone,

I am a first time user of The Scripts (although I have taken many useful tidbits back to my desk from other discussions).

I am currently developing a database that will track sales performance against forecasts. Forecasts and buy plans are entered through forms into static tables. Actual sales data, including sales, weeks of stock, and inventory OH + OO is loaded in weekly using a macro.

The information comes out of the local ICS in a text report, which I then import and format. In order to store the new data, I strip the report through a series of queries, and make new tables with the appropriate fields added to them. The new fields are assigned a name based on the week, so I always know what the data in the future will be called.

The problem I am having is that my report shows all of the data on a quarter by quarter basis - but not all of the sales data is present. The report is designed with controls for the future fields of sales data, but as they are not in the database, I get a long series of #NAME? errors.

How can I format the report to not show the controls with a #NAME? Error?

Thanks

[Rabbit]

There may be a better way to design your report but you can use the On Render event and the IsError function to set the visibility of your controls.