I have an issue with a report that I've developed where the user has the option to either Preview / Print it or Email it to another user. No problem with Previewing or Printing the report....but I have a formatting issue if the report isn't opened in preview mode prior to emailing it.
Here's the deal, depending upon certain criteria of a given field, when the report opens, I have to modify the layout of the report. I do this in the Report_Activate subroutine.
As long as I open the report in preview mode....and then continue on letting it create an email....no problem. It's only when I try to create an email without it opening in preview mode first.
Obviously, the issue is because the code doesn't run unless I open it in preview mode first. Is there anyway around this?
My intermediate fix is to open in preview mode first but was hoping to get around that if I could. I could have a separate report for each different format....but was trying to avoid that option.
Thanks for your help!
Toga
Here's the deal, depending upon certain criteria of a given field, when the report opens, I have to modify the layout of the report. I do this in the Report_Activate subroutine.
As long as I open the report in preview mode....and then continue on letting it create an email....no problem. It's only when I try to create an email without it opening in preview mode first.
Obviously, the issue is because the code doesn't run unless I open it in preview mode first. Is there anyway around this?
My intermediate fix is to open in preview mode first but was hoping to get around that if I could. I could have a separate report for each different format....but was trying to avoid that option.
Thanks for your help!
Toga
