Sum in Report Footer

[mlopes1]

I am running into a curious situation... I have text boxes in a report footer. They are summing the values in columns in the main report. However, if the column happens to contain all zeroes, the summing does not show a zero, it shows nothing. How can I get to see the zero in the summed text box? Thanks as always,

Marco

 

[WayneRyan]

Marco,

You could try setting its default value to 0 (if it has one, I
don't have Access with me). It may not.

You can use the Report Footer Print event to do:

Me.YourTextBox = Nz(Me.YourTextBox, 0)

Or you can change your query to use the Nz function.

I can't try any of these, since I don't have Access with me,
but one of them should work.

Wayne

 

[mlopes1]

You were right in thinking that there is no default value option for the text box but the Print event worked perfectly.

I did not try changing the query to include the function NZ but will design it that way next time.

Thanks for the suggestions,

Marco