hide zeros in report...

[stephendeloach via AccessMonster.com]

I have a report with NetAmount. Under NetAmount it contains numbers. Under
the last number there is always a 0.00, how can I make this not show? Thanks

Stephen

 

[Jeff Boyce]

You are describing something that appears on a printed report. Without some
idea of how the report is designed, I can only guess...

You have a control on the report that displays something that equals (or
defaults) to zero.

If you don't want to see that, set the control property .Visible=False. Or
delete the control.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[stephendeloach via AccessMonster.com]

Exactly... I think it is set to default = 0... Its an invoice with line items
in the Details section... as the lines go down the netamount goes down..
leaving the last number 0.00 even if there is nothing on the line.. the
NetAmount controlsource is =[Quantity]*[Test] is that helps any?

 

[Klatuu]

Use the Format property of the text box. Something like this should do:
"#0.00;#0.00;#"
The first part is for positive numbers, the second for negative, and the
third is for zero. You can a a fourth, for Null, if needed.
--
Dave Hargis, Microsoft Access MVP

Exactly... I think it is set to default = 0... Its an invoice with line items
in the Details section... as the lines go down the netamount goes down..
leaving the last number 0.00 even if there is nothing on the line.. the
NetAmount controlsource is =[Quantity]*[Test] is that helps any?

You are describing something that appears on a printed report. Without some
idea of how the report is designed, I can only guess...

You have a control on the report that displays something that equals (or
defaults) to zero.

If you don't want to see that, set the control property .Visible=False. Or
delete the control.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[stephendeloach via AccessMonster.com]

I figured it out...
If NetAmount = 0 Then
NetAmount.Visible = False
End If

simple as that!

Exactly... I think it is set to default = 0... Its an invoice with line items
in the Details section... as the lines go down the netamount goes down..
leaving the last number 0.00 even if there is nothing on the line.. the
NetAmount controlsource is =[Quantity]*[Test] is that helps any?

You are describing something that appears on a printed report. Without some
idea of how the report is designed, I can only guess...

[quoted text clipped - 15 lines]

 

[stephendeloach via AccessMonster.com]

Ok what I did didnt work when you printed. Now I have entered what you
suggested and it works but my numbers arent in dollars??

Use the Format property of the text box. Something like this should do:
"#0.00;#0.00;#"
The first part is for positive numbers, the second for negative, and the
third is for zero. You can a a fourth, for Null, if needed.

Exactly... I think it is set to default = 0... Its an invoice with line items
in the Details section... as the lines go down the netamount goes down..

[quoted text clipped - 20 lines]