hide report lines with subtotal = 0

[h2mhd]

Hi

i have a report with thoses fields:

- date
- item
- description
- qty
- price
- sub total

what i want to do is when we enter a descrition with no quantity or quantity =0, i just want to hide the field qty, price, sub total.

i try it but when i hide those fields the entire fields are hidden so i didnt see the lines with a quantity > 0 and sub total on my printed invoice

is there someone who can help me find a way to do that?

thanks a lot

 

[dhookom]

How did you "try it"? Did you try conditional formatting or code or macro?

I would probably use code in the On Format event of the section of the report containing the controls.

Duane
Hook'D on Access
MS Access MVP

 

[h2mhd]

hi dhookom

thanks for your response

heres what i tried:

Private Sub Détail_Print(Cancel As Integer, PrintCount As Integer)
On Error Resume Next
PageSum = PageSum + Me.subtotal
if me.subtotal = 0 then
me.qte.visible=false
me.price.visible=false
me.souttotal.visible=false
End Sub

the problem is when i hide a field it hides all the lines even if the subtotal is greater than 0

i really dont know how to do that??

do you have a trick for me?

Thanks a lot

 

[dhookom]

You don't have any code that sets the controls back to visible. You are also missing "End If".

Try code like:

[indent]Me.qte.visible = Me.Subtotal <> 0
Me.price.visible = Me.Subtotal <> 0
Me.souttotal.visible = Me.Subtotal <> 0[/indent]

Duane
Hook'D on Access
MS Access MVP