How to make check box for select specific field form table?

G

ghost

Greeting,
I would like to create a form that able the user to select fields using
check box and allows it to print the specified fields. For example, I have
Student table and it has the following fields:
First name
Mid name
Last name
Age
Group No.
…..

Suppose that a user wants to display or print only first name, last name and
group no.

How can I do that please??? Should I use a query or form or what??

Many thanks
 
A

Allen Browne

You will need to be comfortable writing VBA code to achieve this.

Design the report so it has all the fields you could wish to display.

Design the form where the user selects the fields they want to show.

Write code in the Open event procedure of the report, so set the Visible
property of the controls, based on the user's selection in the form.

You probably want to set the Left and Width of the controls as well, so as
to make the best use of available space. This will be specific to your
fields and the layout of the report.

If the report's Detail section has several rows of controls, set their Can
Shrink to Yes, and assign the Control Source of only the controls that
actually will contain data. The attached labels will also have to be text
boxes so they can shrink as well.

Not a simple job, really.
 
Top