G
Guest
Hi, everyone,
I have a report that shows open product jobs. I have it grouped by product
type. All but one of my products is measured in quantities of bottles; the
'special' product is mesasured in kilograms.
I have both fields on my report, but I want the report to show the bottle
quantity and hide the kilogrammes, unless the product type is the 'special'
one; then I want the report to hide the Bottle Quantity and show the
kilogrammes. I've tried writing an If statement in VBA in the report's
OnOpen event:
If [ProdType] = "Dispense" Then
[BottleQty].Visible = False
[Kgs].Visible = True
Else:
[BottleQty].Visible = True
[Kgs].Visible = False
End If
However, this did not work; I got a debug msgbox that said that the
'property has no value' which I took to mean I used an invalid property for
that control. The report is open from a switchboard.
Any suggestions?
Thanks!
Chris A., Las Vegas
I have a report that shows open product jobs. I have it grouped by product
type. All but one of my products is measured in quantities of bottles; the
'special' product is mesasured in kilograms.
I have both fields on my report, but I want the report to show the bottle
quantity and hide the kilogrammes, unless the product type is the 'special'
one; then I want the report to hide the Bottle Quantity and show the
kilogrammes. I've tried writing an If statement in VBA in the report's
OnOpen event:
If [ProdType] = "Dispense" Then
[BottleQty].Visible = False
[Kgs].Visible = True
Else:
[BottleQty].Visible = True
[Kgs].Visible = False
End If
However, this did not work; I got a debug msgbox that said that the
'property has no value' which I took to mean I used an invalid property for
that control. The report is open from a switchboard.
Any suggestions?
Thanks!
Chris A., Las Vegas