hide zeros in report...

  • Thread starter stephendeloach via AccessMonster.com
  • 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
 
J

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
 
S

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

Guest

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
 
S

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]
 
S

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top