How do you reference names in reports?

[Andreas]

In a form, in order to hide or show an item based on the value of a
variable, I do the following:
If [InvoiceCustDetails].[Discount] = 0 Then

Discount.Visible = False

Else

Discount.Visible = True

End If





In the report, it doesn't recognize my [Discount] variable. How should I
reference it?

 

[Allen Browne]

Andreas, that should work in a report, provided:

a) There is a control named Discount (not just a field), and

b) You put this code in the Format event of the section the Discount control
is in.

It might be more efficient to use Conditional Formatting and use (say) white
text.

 

[Andreas]

Thanks a lot, it was your 2nd suggestion. I had to put it in the Format
event of the section the Discount control
is in.

I was using the form load event.

Andreas, that should work in a report, provided:

a) There is a control named Discount (not just a field), and

b) You put this code in the Format event of the section the Discount
control is in.

It might be more efficient to use Conditional Formatting and use (say)
white text.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

In a form, in order to hide or show an item based on the value of a
variable, I do the following:
If [InvoiceCustDetails].[Discount] = 0 Then
Discount.Visible = False
Else
Discount.Visible = True
End If

In the report, it doesn't recognize my [Discount] variable. How should I
reference it?