467,135 Members | 1,199 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,135 developers. It's quick & easy.

changing textboxes in a report at run time

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
  • viewed: 1160
Share:
2 Replies

<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
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.

Similar topics

2 posts views Thread by bh | last post: by
1 post views Thread by Mehrdad | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.