Visible Property of Control on a Report

  • Thread starter Thread starter JD McLeod
  • Start date Start date
J

JD McLeod

I have a form that prints audit findings. The findings are grouped by
section. For any given section, you may have multiple findings, one finding
or no findings at all. I wanted to have a text box on the report with a
default value of “Noneâ€. If the findings table for this particular section
was blank (null) the “None†control would print on the report. If however,
the user has entered a finding in the findings table, the formula/code for
the “None†control would set the visible property to NO so that the control
was not printed. I saw a similar post related to this and thought it could
help me, but didn’t fully understand how to implement it. Any help would be
much appreciated. I am a relatively new user of Access.

I had considered putting “None†as the default value in the findings table,
but since the user may have multiple findings for the same section, I would
have no way to know how may findings to anticipate.

Thanks.
 
Best bet is to learn a little bit of VBA and work with the Build A Code click
event on Form Load.

It would be similiar to something like this

If IsNull(Me.mytext) Then

Me.mytext = "None"

else Me.mytext.visible = False

End If

Untested, but just to show you the idea
 
Back
Top