Hide control

  • Thread starter Thread starter ckerns
  • Start date Start date
C

ckerns

I have a checkbox in recordset. I would like to show certain controls
in detail section depending on it's value.

If True show controls a, b, c.
If false show d.

Where and how should I code?

tia
 
I have a checkbox in recordset. I would like to show certain controls
in detail section depending on it's value.

If True show controls a, b, c.
If false show d.

Where and how should I code?

tia
Click to expand...

You can place this code in the report's Detail Format event:

[A].Visible = [CheckBoxField]
.Visible = [CheckBoxField]
[C].Visible = [CheckBoxField]

[D].Visible = Not [CheckBoxField]
 
I have a checkbox in recordset. I would like to show certain controls
in detail section depending on it's value.

If True show controls a, b, c.
If false show d.
Click to expand...


Use the Format event of the section containng the controls:

Not sure what you mean by "checkbox in recordset". If its
just another control on the report, then you can use:

Me.A.Visible = Me.checkbox
Me.B.Visible = Me.checkbox
Me.C.Visible = Me.checkbox
Me.D.Visible = Not Me.checkbox
 
You must log in or register to reply here.

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

How make a control conditionally invisible? 1
Setting checkbox state thru code 1
show/hide SubReport 2
hide label & checkbox if ..... 8
Hiding Section Detail 7
Hide "Grouped" Controls 1
Hide Line on Repeating Values 7
Hiding controls on reports in Access 1

Back
Top