visible fields

A

Amin

Hi
I have a subreport based on query with 25 (Yes/No)fields.
how can I make those fields visible if the value is Yes
Thanks
 
M

Marshall Barton

Amin said:
I have a subreport based on query with 25 (Yes/No)fields.
how can I make those fields visible if the value is Yes
Click to expand...

In the Format event of the section containing the 25
controls:

Me.control1.Visible = (Me.control1 = True)
Me.control2.Visible = (Me.control2 = True)
. . .
 
A

Amin

Thanks Marsh
-----Original Message-----


In the Format event of the section containing the 25
controls:

Me.control1.Visible = (Me.control1 = True)
Me.control2.Visible = (Me.control2 = True)
. . .
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split form 0
ASK Field Formatting 1
Filtered view of Visio Chart 0
Subreport visability based on query 1
Newbie Help - IF Yes No Function 0
How to make scroll bar permanently visible, Word 365 0
Match table shading (color) to Visio color/Transparency 1
How to clear areas of a locked Doc after each use-- 0

Top