Have you tried Can Shrink?Can Grow, Shrink

Otherwise you could use unbound fields and set their values and visibility with VBA when you load the report

Can shrink rolls up the field, but not the label.

But, I want to display fields that haven't been populated, and not display fields or labels for fields that have been populated, so that my client can provide the necessary information.

Thanks,

John

So there's no real reason to have the fields on a report if they're null, you shouldn't be editing values on a report, all we would need are the labels. Are you sure we shouldn't be making a form?

Hi John, by "move to the top of the report," do you mean sorting the data so that the records with empty fields appear as the top records?

If so, then this is a tricky thing to do, because not one field is empty all the time, so you can't sort by just one field.  In the first row, maybe Field1 is empty.  The 5th row, Field3 may be empty.  In the 100th row, maybe Field1, 5, and 7 are empty.  In other words, if you want ANY record that has an empty field to appear at the top, then no conventional sorting method can be done.

If it were me doing this, I would create a calculated Yes/No field in the query that indicates whether a record has an empty field or not, where True = has empty field(s).  Then I would sort by this Yes/No field ascendingly, since true comes before false in ascending order.  Then all the records with empty fields will be on top.

Then you still need VBA (the report's Format event procedure) to hide/unhide fields, etc. for each record.

Just wanted to get back to the forum. Found an answer on ChatGpt. The code pulls all fields and labels without data. So it produces a list of fields that need data:
=IIf(Nz([Claim Number],"")="","Claim Number:
","") & IIf(Nz([Date of Accident],"")="","Date of Accident:
","") & IIf(Nz([Insured],"")="","Insured:
","") & IIf(Nz([Underwriting Company],"")="","Underwriting Company:
","") & IIf(Nz([AccidentLocation],"")="","Accident Location:
","") & IIf(Nz([Gender],"")="","Gender:","")

Thanks,

John