How do I replace missing values with another character in a Report

[Guest]

I want to show missing values in a report as a dash instead of a blank. How
do I do this?

 

[Rick B]

Nz([YourFieldName],"-")

 

[John Spencer]

Or you can use the format property of the control(s) to specify that it show
a dash or whatever other character you want.

For text, set the format to
@;-

For numbers, set the format to
#,##0;-#,##0;0;-

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

Nz([YourFieldName],"-")

--
Rick B

I want to show missing values in a report as a dash instead of a blank.
How
do I do this?

 

[Marshall Barton]

I want to show missing values in a report as a dash instead of a blank. How
do I do this?

If by "missing" you mean Null, then use a custom format:

For numeric values, use the fourth format setting. E.g.
$#,##0.00;($#,##0.00);;"-"
For a text value:
@;"-"