Can you hide a label when field not in use???

[JustMaybe]

Hi.

Does anyone know how to set a textbox label on a form so that it only shows if there is information to go in it!! Rather than print out an empty field!


...thank you so much if anyone can solve this!!!

 

[JustMaybe]

SORRY!!.. i meant a field in a report....this is the wrong forum as well..... can anybody help??

Don't dare post this in the report forum aswell...after last time!

 

[Stew]

There are, of course, other ways (and maybe simpler) but I use a text box instead of a label and set the control source of the text box to something like the following:

=IIf(IsNull([cont_id])," ","Concentrator ID")

It checks the [cont_id] field for a value, if it is null then it sets the value of itself to a blank space (thus nothing shows) and if there is a value in the [cont_id] field, it sets itself to "Concentrator ID" which acts as the label.

Hope this helps.

Paul