User selectable fields in a report.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all you friendly people.

I need to create a report that enables the users to select the fields they
want to see from a form. Problem is i don't want to just hide/unhide the
selected fields as this would create empty spaces in between selected fields.
I want the report to space and align the selected fields as the report is
generated. This should be possible but i recon it would involve some serious
coding....

Any suggestions welcome.
 
VanmaN said:
Hello all you friendly people.

I need to create a report that enables the users to select the fields they
want to see from a form. Problem is i don't want to just hide/unhide the
selected fields as this would create empty spaces in between selected
fields.
I want the report to space and align the selected fields as the report is
generated. This should be possible but i recon it would involve some
serious
coding....
Click to expand...

For Controls that do not have another control alongside them, you can use
CanShrink to shrink them (1) to the size necessary to display only the text
contained in the Field in the Control Source, or (2) shrink them away
entirely if empty. There is no similar property for growing / shrinking
Controls horizontally... that is, if one Control's display is suppressed to
move the follwing Control on the same line to the Left. And, yes, I do think
that would take more than minimal knowledge of VBA.

Larry Linson
Microsoft Access MVP
 
Duane, That is an absolute fabulous QBF app you wrote Great stuff, this will
surely be used in my app i am creating. Thanks, your the MAN!!!
 
Back
Top