Report Sections - Controls

  • Thread starter Thread starter Paul Ilacqua
  • Start date Start date
P

Paul Ilacqua

What is the proper method to hide / show either sections or controls within
sections of a reprt through VBA. Some say use twips some say use strings.
What is the proper method and should I use twips or inches. My setup
defaults to inches.

Paul
 
What is the proper method to hide / show either sections or controls within
sections of a reprt through VBA. Some say use twips some say use strings.
What is the proper method and should I use twips or inches. My setup
defaults to inches.

Paul
Click to expand...

The usual method to hide or show report sections or controls is to
simply make them visible or not.
Me.[ControlName].Visible = False or True (A Control]
Me.Section(0).Visible = False or True (Detail Section)
Or you can use the Cancel argument in the control's Format event to
not show that section.

Now if this isn't what you mean, perhaps you should post back with a
bit more detail of what it is you a trying to do.
 
It's a report with optional comments below the main record in the detail
section, if the request form's show comments box is checked then the detail
section's height would be x to accommodate the extra comments text box and
label, if the box is not checked it would be y a "shorter" version of the
detail section etc....
Thanks
Paul


fredg said:
What is the proper method to hide / show either sections or controls
within
sections of a reprt through VBA. Some say use twips some say use strings.
What is the proper method and should I use twips or inches. My setup
defaults to inches.

Paul
Click to expand...

The usual method to hide or show report sections or controls is to
simply make them visible or not.
Me.[ControlName].Visible = False or True (A Control]
Me.Section(0).Visible = False or True (Detail Section)
Or you can use the Cancel argument in the control's Format event to
not show that section.

Now if this isn't what you mean, perhaps you should post back with a
bit more detail of what it is you a trying to do.
Click to expand...
 
Back
Top