Re: [MS_AccessPros] Re: printing report issue - help

 

ps

make the Default View for the report = Print Preview (so code will execute), not Report View

On 7/19/2018 1:59 PM, crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] wrote:

hi Rod,

Do you still need an answer?

if report heading section is not showing, right-click on a blank part of report in design view and choose to show report header/footer. Close the sections so they don't take unintended space, and assign event to what is labeled 'On Format' on the property sheet for the report header section, and put code to change the label caption there

if the label caption in the page header needs to change during the course of the report, put the code to do it on the Format event of a group section

have an awesome day,
crystal

On 7/18/2018 1:13 PM, desertscroller@cox.net [MS_Access_Professionals] wrote:

Thanks crystal,

Find the solution, needed to resolve needs.

Thanks again

Rod

---In MS_Access_Professionals@yahoogroups.com, <desertscroller@...> wrote :

Thanks for the reply.  The title is not header (sorry for mis-info).  It is a label as a page header.  The update of the information is executed on load also used on open.  The preview looks great. But when print is used the output has the old info.

Did not find Report Header Format event.

Rod

---In MS_Access_Professionals@yahoogroups.com, <strive4peace2008@...> wrote :

> "The title is updated on open"

not sure where code is executing ... but try the Report Header Format event

Also realize that Report View doesn't run much code -- use Print Preview

have an awesome day,
crystal

On 7/18/2018 11:41 AM, desertscroller@... [MS_Access_Professionals] wrote:

I have a report that works great except for one issue.  The title is updated on open but when report is printed it shows the title that was defined at design time.  The report is printed and saved as a PDF both having the issue.  The displayed report appears correct.

 I.E.

Design:

 SCHOOL BUS EVACUATIONS REPORT FOR 2013/2014

Report time:

 SCHOOL BUS EVACUATIONS REPORT FOR 2017/2018

The application is compiled.  Using ACCESS 2013 on Windows 10.

Any suggestions how to insure proper date is reported.

__._,_.___

---

Posted by: crystal 8 <strive4peace2008@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (6)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___