By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,557 Members | 1,406 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,557 IT Pros & Developers. It's quick & easy.

changing textboxes in a report at run time

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a

<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

P: n/a
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

This discussion thread is closed

Replies have been disabled for this discussion.