changing textboxes in a report at run time

tricard

Hello all,

I have a report that displays four pieces of data by default, but two
of these fields are not neccessary for all people to see.

I have made a form that gives the user the choice to select what data
to display when the report is being run. After the selection has been
made on the form, the report is opened in design mode, saved, closed
and reopened it in preview mode. I was wondering if there is a cleaner
way to modify the report than opening it in deisgn, and then reopening
it in preview mode?

Tim

Aug 16 '06 #1

Arno R

<tr*****@gmail.comschreef in bericht news:11**********************@m79g2000cwm.googlegr oups.com...

Hello all,

I have a report that displays four pieces of data by default, but two
of these fields are not neccessary for all people to see.

I have made a form that gives the user the choice to select what data
to display when the report is being run. After the selection has been
made on the form, the report is opened in design mode, saved, closed
and reopened it in preview mode. I was wondering if there is a cleaner
way to modify the report than opening it in deisgn, and then reopening
it in preview mode?

Tim

You could do this in runtime, while the report opens

On your report I would make the choice-controls invisible.
On your form e.g. called FrmDisplayChoice you need two controls like
ShowControl1 and ShowControl2 (yes/no values here)
Then you need some code in the report's open-event like
Me!Control1.visible = Forms!FrmDisplayChoice!ShowControl1
Me!Control2.visible = Forms!FrmDisplayChoice!ShowControl2

Arno R

Aug 16 '06 #2

tricard

Thank you for the help. That is much easier to deal with.

Tim
Arno R wrote:

<tr*****@gmail.comschreef in bericht news:11**********************@m79g2000cwm.googlegr oups.com...

Hello all,

I have a report that displays four pieces of data by default, but two
of these fields are not neccessary for all people to see.

I have made a form that gives the user the choice to select what data
to display when the report is being run. After the selection has been
made on the form, the report is opened in design mode, saved, closed
and reopened it in preview mode. I was wondering if there is a cleaner
way to modify the report than opening it in deisgn, and then reopening
it in preview mode?

Tim

You could do this in runtime, while the report opens

On your report I would make the choice-controls invisible.
On your form e.g. called FrmDisplayChoice you need two controls like
ShowControl1 and ShowControl2 (yes/no values here)
Then you need some code in the report's open-event like
Me!Control1.visible = Forms!FrmDisplayChoice!ShowControl1
Me!Control2.visible = Forms!FrmDisplayChoice!ShowControl2

Arno R

Aug 16 '06 #3