In the control source on a text box in a report I put the following.
=Nz([Forms]![Metrics Reporting]![cboareas],"All Areas")
I want it to display the combo box selection but if none is selected I need it to say "All Areas"
It displays the selection of the combo box but does not display "All Areas" when null.
Any ideas why this is not working?