How to condition Making Fields Visible in a Report

[Juan1313]

Hi everybody

Im new to this so i appreciate any help. I am working on a report that takes data from a Query but i only want fields in the report to be visible only if they have any value and are not empty, i would also like the labels beside to share the same condition. I'm pretty sure this is possible but i cannot figure out how to do it....


Thanks in advance guys

[ranman256]

If the field is empty the the data will be invisible anyway.
but
in the ON PRINT event, set:

me.textbox.visible = not IsNull(me.textbox)

[CJ_London]

providing the label is bound to the value control, hiding the value control will also hide the associated label.

If they are currently not linked, you can link them by

in design view
select the label
use ctrl-X to delete it
then select the control it is linked to
and use ctrl-V


in the report format event put

me.mycontrolname.visible=not isnull(mycontrolname)


the alternative is to use conditional formatting - which you will also need to use if the report is continuous

conditional formatting cannot hide a control but can set the back and fore colours to the same as the section back colour (usually white). Also labels are not affected by conditional formatting so you cannot hide these

for the value control it would be

Field Value Is...equal to....Null