Conditional Format of Labels

[LJDL]

Hi, apologies if this has already been answered in the many conditional
format questions.

I have a field that not every employee will enter info into. On my report I
have been able to use conditional formatting to 'white out' the data in the
text box if the value is zero. This works fine but I have not been able to
hide the label attached to this field.

Basically, if there is data then I want to see the label and the data, if
there is no data i don't want to see anything.

Any ideas?

 

[John Spencer]

You can change the Label to a text control and set the text control's
value to the label of the caption.

Control Source: ="This is my label"

Then you can use conditional formatting on the control.

I'm assuming you are using a continuous form. If you are using a single
form then you could just show or hide the control or the label using VBA
code in the Current Event of the form.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================