sherlocked
Registered User.
- Local time
- Today, 06:19
- Joined
- Sep 22, 2014
- Messages
- 125
Experts,
I have a report that I open in acViewReport, acDialog mode. I am attempting to resize the report dialog so that the user press a button that takes a screen shot of the report and pastes it in an email. For reasons more complicated than I have time to explain here, SendObject isn't an option for this report.
Below is the code in the "On Open" event of my report. I have to set focus because there is another form open behind the report when the user clicks a menu button to launch the report. This does successfully open and resize the window, but I am only getting partial rendering of the report; my unbound text fields appear with data in them, but my labels and buttons do not appear. Is there any obvious reason for this? :banghead:
I have a report that I open in acViewReport, acDialog mode. I am attempting to resize the report dialog so that the user press a button that takes a screen shot of the report and pastes it in an email. For reasons more complicated than I have time to explain here, SendObject isn't an option for this report.
Below is the code in the "On Open" event of my report. I have to set focus because there is another form open behind the report when the user clicks a menu button to launch the report. This does successfully open and resize the window, but I am only getting partial rendering of the report; my unbound text fields appear with data in them, but my labels and buttons do not appear. Is there any obvious reason for this? :banghead:
Code:
DoCmd.SelectObject acReport, "rptCapitol", False
DoCmd.MoveSize , , , 20000