I figured out a way to HIDE fields if they do not meet a certain criteria on a report and I have used the can shrink figure to squeeze everything together, however, I still have some big gaps in the report. Is there anyway to remove all the "spaces"?

The reason for the HIDING is that I could not filter the data because I created a calculated field on the report and if the person was noted as "COMPLETED", I did an event and hid the fields so the information would not appear. I made a simple report sorta complicated but it works except for the extra white spaces.

Thanks,
Deborah

Resize each section so that it is only as high as it needs to be. Select all the controls on each row and change their top property to 0. Then drag the bottom of the section up to the bottom of the row of controls. Also make sure that controls do not overlap. Access will not shrink vertical space if controls overlap.

I did all that you stated and it still did not work correctly. I had to go in and generate an ON print event and use the following:

If done = "completed" Then Me.NextRecord = True
If done = "completed" Then Me.MoveLayout = False
If done = "completed" Then Me.PrintSection = False

It worked like a charm!

Thanks for all the help.
Deborah