Need Visible-NotVisible on rpt

[Bonnie]

Hi there! Using A02 on XP. Use Visible/Not Visible on lots
of forms, why can't I have fields on a report visible on
the report open event? Where must I do it? I have a few
fields that may or may not need be visible. I tried in the
Control Source to do this: =IIf(Val([Journal])=-
1,Format$([GrossDistr]-[FIT]-[LoanBalAmt]-
[StateTax],"$#,##0.00"),([WireAmt].[Visible]=False)) just
doesn't work. I know it's something simple but it would be
so nice if I could do it.

Thanks in advance for any help or advice!!!

 

[Guest]

The control source is just telling Access where to get
it's value from

One way to do it, is in your report, assuming these
values are in the detail section of your report, go into
the "On Format" property of your Detail section, and
start a new event procedure. Then you can simply do a
Select Case or If-Then statement (like the example below)
for your condition like the example below

If condition_to_be_tested= -1 Then
Me.FIELDTOMAKEVISIBLE.Visible = False
Else
Me.FIELDTOMAKEVISIBLE.Visible = True
End If