Report Display controls based on values in record (1 Viewer)

[rth@trinitylabs.org]

I have a Report that displays students (first name, last name, class list, and if they have a car or not). I want the report to show each student on a line, and display a Label ("CAR") if said student has access to a car.
I tried Report -- Current Event, but that seems to do nothing, so tried the On Load Event, which just makes every record show "CAR."

Here is the equation:

If chkCar = True then
  chkCar.Visible = True
  lblCar.Visible = True
End If

the chkCar & lvlCar Visible States are set as "No" in the Properties Sheet.

Am I using the wrong Event? Or can Reports do this sort of thing?

Thanks in advance.

 

[MajP]

Look at the report's sectin onPaint and onFormat events

Section.Paint event (Access)

Office VBA reference topic

learn.microsoft.com

 

[arnelgp]

there is a simple hack for this.
create a Query (Query1) from your table.
then from the Query create your report.
note that the "chk" field has Wingding as it's Font.

 

[Pat Hartman]

I would use the detail section's Format event. You also need to toggle the value.

If chkCar = True then
  chkCar.Visible = True
  lblCar.Visible = True
Else
  chkCar.Visible = False
  lblCar.Visible = False
End If

 

[Gasman]

Could that be shortened to ?
ChkCar.Visible = chkCar
Etc etç

 

[rth@trinitylabs.org]

That works great. Thanks.

there is a simple hack for this.
create a Query (Query1) from your table.
then from the Query create your report.
note that the "chk" field has Wingding as it's Font.

Nice. Let the Query do all the heavy lifting. That works great. Thank you very much.

 

[rth@trinitylabs.org]

Could that be shortened to ?
ChkCar.Visible = chkCar
Etc etç

You are correct. Should have done that here. Makes code more compact. Thank you.