exclude some fields from a report depending on whether they contain data

[tallitin]

I want to produce a report based on a table (or query - could be either) that doesn't reproduce every single field in the report (or query). Whenever a field in a record has no data in it, I do not want it to appear in the report. How do I achieve this? Any help would be appreciated.

[ItsMe]

Have you tried using the .Visible property? Maybe an If Then Statement would be appropriate.

[tallitin]

that sounds like a good idea. However the 'visible' property in the report property sheet only gives me the option of 'yes' or 'no'. Are you suggesting I should build some code into the control on the report? If so, should I use 'expression builder' to do this?

[ItsMe]

I would not use expression builder. Instead, I would use VBA to evaluate the field and then decide whether or not to set the Visible property to equal yes or No.

[tallitin]

Hey, thanks for that. Any idea what the Code should be?

I would not use expression builder. Instead, I would use VBA to evaluate the field and then decide whether or not to set the Visible property to equal yes or No.

[June7]

Setting a control to not visible doesn't accomplish much. The control still occupies space and there will be blank area on report, no different from an empty field.

[tallitin]

Yes, I get that. Someone suggested the formatting of the report also needs an action applied to it so that it shrinks accordingly.

[June7]

Where will it shrink? Just because there are empty field(s) doesn't eliminate the record. The record still occupies space if only one field has data.