hide zeros in report...

  • Thread starter Thread starter stephendeloach via AccessMonster.com
  • Start date Start date
S

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
 
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
 
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?
 
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


stephendeloach via AccessMonster.com said:
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?

Jeff said:
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
Click to expand...
Click to expand...
 
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...
Click to expand...
[quoted text clipped - 15 lines]
Click to expand...
 
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..
Click to expand...
[quoted text clipped - 20 lines]
Click to expand...
 
Back
Top