I am really new to Access, and I hope you can help.

I created a report that has 6 columns. The first column is an unbound text box representing a year, the remaining columns are being pulled from a query. I have set the last five columns so they will shrink or grow and when there is no data they do not show. My problem is when those fields are blank I want the unbound year box not to show as well. Is this possible? I do not know anything about writing codes etc.

Thanks for any help you can give me.

Originally posted by Eaton1379
I have set the last five columns so they will shrink or grow and when there is no data they do not show.

Why would you want to show a report with no information?

On the Report's properties there is the NoData event.

I probably didn't explain myself well enough. The report will show data from 1995-2034. Each line will have 5 data elements for the particular year. The information that will be reported is for 83 different individuals. Some of these individuals will have information for all of the years while others will only have information for a few of those years. I don't want the report to show the years if there is no data associated with it. As I have the report now if Mr. J has information for 1995 , 1998 and 2000, the page for him shows 1996 then nothing in the adjacent columns , 1997 then nothing in the adjacent colums, etc all the way to 2034 when there is no data. I want the text box to disappear if there is no information for that year in the adjacent columns and the lines for the years with information in them to be next to each other as you scroll down the page. Hope this makes what I am trying to do clearer.

Modify your query so that only rows with data are included.