CODEWITHSUNDEEP
ms-accessreportingconditional-statements
webworm
webworm

Reputation: 11019

Access conditional formatting - adding text instead of color?

I have an Access 2003 report and some of the fields within the report are NULL. I can use conditional formatting to change the color and other aspects of the text-box control but what I want to do is to display "XXXXXXXXXXXXXX" in fields where there is no data (i.e. NULL). Can this be done using conditional formatting?

Upvotes: 1

Views: 1409

Answers (1)

Fionnuala
Fionnuala

Reputation: 91356

The best place to do this is in the query which the report should be based on. However, it is possible to set a control in a report to, say: 

 =Nz(MyField,"Text")

You will have to ensure that the control has a name other than the default assigned name, which is the name of the field.

Upvotes: 1

Related Questions