Write label only if value exist

[hlubpc09]

I would like to display the label of a field name only if the value of the field name exist. Can it be done in Access? If yes, how?

Lots of Thanks!

 

[jeffshex]

Is this the label on the form, report???
Using VBA, an if statement in the right place can make the item show with the .visible statement.

 

[dhookom]

Just replace the label with a text box having a control source like:
="Caption Value " + [Field Name]
Make sure the control can't expand and don't display any wider than "Caption Value ".

Duane
Hook'D on Access
MS Access MVP