conditional format

  • Thread starter Thread starter _Bigred
  • Start date Start date
B

_Bigred

If a field Worker is empty


how do I conditional format to put "Vacant Position" over that field.

I'm trying to use a label that says Vacant Position , but I can't figure
out how to hide the label if Worker has text in it vs if it's empty show
this hidden label?

TIA,
_Bigred
 
Hi Bigred - You can't use Contitional Formatting so what I do is add a an
Unbound Text box to the report and in the expression builder put -

=iif(isnull[Worker],"Vacant Position",[Worker])

I sometimes put this into the Query itself if I am using the field in more
than one location or report/form.

Hope this helps - yours, Dika
 
_Bigred said:
If a field Worker is empty

how do I conditional format to put "Vacant Position" over that field.

I'm trying to use a label that says Vacant Position , but I can't figure
out how to hide the label if Worker has text in it vs if it's empty show
this hidden label?
Click to expand...


You can use a text box with the control source expression:
=Nz(Worker, "Vacant Position")
 
Back
Top