I have an access report that pulls data from an outside database.
Instead of using labels (because its hard to line them up properly) with the text box fields I have created an expression to include the label I need inside - For example: ="Name: " & [CONTACT_NAME]
Is there a way to use the conditional formatting to change the font color of just "Name" or just the data [CONTACT_NAME] or will it always apply to the whole field?
Thanks for any help!