Show zero in empty cells?

[Bokazoit]

Some of my the data in my report is 'empty' cells. How to change an empty cell with a 0 (Zero)?

 

[Trendsetter]

This is an old argument!
If a cell is empty is could be that it is NULL meaning that nothing exists or that the calculation has not been done or did not yield a result or is a zero length string.
Anyway......
If the field is a NULL you can use the Nz() function that converts it to zero:
Me.ControlName = Nz(Me.ControlName, 0) or you can set the default property at the form or table level to zero:
Default = 0

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk

 

[dhookom]

You can simply use the Format property of the text box. There is an example in Help:

$#,##0.00[Green];($#,##0.00)[Red];"Zero";"Null"

In your case, replace at least "Null" with 0.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]