Access conditional formatting - adding text instead of color?

Question

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?

Answer 1

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.