|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 11th, 2007, 03:04 PM
posted to microsoft.public.access.reports
|
|||
|
|||
hide zeros in report...
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 -- Message posted via http://www.accessmonster.com 
|
|
#2
July 11th, 2007, 03:11 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
hide zeros in report...
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" u32891@uwe wrote in message news:7503e8fc6073d@uwe... 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 -- Message posted via http://www.accessmonster.com
|
|
#3
July 11th, 2007, 03:33 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
hide zeros in report...
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 Boyce wrote: 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 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 -- Message posted via http://www.accessmonster.com
|
|
#4
July 11th, 2007, 04:18 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
hide zeros in report...
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" wrote: 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 Boyce wrote: 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 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 -- Message posted via http://www.accessmonster.com
|
|
#5
July 11th, 2007, 04:20 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
hide zeros in report...
I figured it out...
If NetAmount = 0 Then NetAmount.Visible = False End If simple as that! stephendeloach wrote: 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] Stephen -- Message posted via http://www.accessmonster.com
|
|
#6
July 12th, 2007, 03:22 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
hide zeros in report...
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?? Klatuu wrote: 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] Stephen -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200707/1
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
