Making changes stand out

[Jelle]

One of my acces reports needs to point the recipient to what fields in it are non-empty(changed). Most fields in the report will be empty, but some might have a default value.
How can I do this, preferably with some VBA. I tried looping over the controls in the form and setting ctl.Properties("Font weight") = "bold", but that does not work. please tell me what does?

 

[Smart]

Try conditional formatting

In your report select a field then on the menu bar select format , conditional formatting

 

[Jelle]

How should I test for a non-empty value then? I assumed that putting

if not equal to ""

it would test for the two double quotes instead of an empty string.

 

[Smart]

when in conditional formatting change condition from field value is to expression is

Then in the next field type

[yourfieldname] Is Not Null

That should do the trick