Sendkeys is the only way that I know of

    DoCmd.OpenReport "CustomerR", acViewPreview
    SendKeys "{END}", True

Thanks, Adam.

Yea, sorry not good news, everything I've ever seen about it is with send keys. There are ways to print just the last page, but it doesn't work in print preview, just direct to printer.

I found a few different solutions, tested them and guess what, NONE of them worked.
If you need the Num Lock to remain in its current state check out the Caps Lock On Off Extended Cut.

Why do you need to?

Alex, the report I open is 32 pages long in order to get the running balance to be right, and I'm lazy and didn't want to click on the arrow at the bottom of the page, LOL.

Kevin, thank you for trying to find a solution. I'm like you, I tried lots of things, but nothing worked. I'm sure I have spent more time trying to find a solution, than I will ever use in clicking the "go to last page" button at on the report. :)    Just trying to learn something new.

Could you not just create a summary report with just the info you need?

Alex, if it can be done, I haven't been able to figure out how.  I tried just pulling the data for the current year, but the running sum is than wrong because it starts with Jan 1, instead of the first of the data which is 2017.  I was doing a new entry for each year of Balance Brought Forward, but then was running into other issues.  I don't look at the report very often, so I'll just go ahead and click the "go to last page" button.

A web browser can open a PDF file at a specific page so you can use that to your advantage.  For instance, this URL opens the PDF at page 6:

     file:///C:/My Documents/MyPDF.pdf#page=6

It has to be an existing page number, so you need to find the page count of your report.  Create a report footer.  In the footer's Print event, assign the page count to a global variable.  Since the report footer is the last thing to be printed, the page count at that point must be right.  The VBA code is:

     GlobalVar = Me.Pages

Run the report, output it to a PDF with DoCmd.OutputTo.  Set the final option to "False" (which is the default anyway) so the PDF does not open, because you want it to be opened later by the web browser:

     DoCmd.OutputTo acOutputReport, "MyReportName", acFormatPDF, "C:\My Documents\MyReportName.pdf", False

Finally, you use VBA to open the web browser and the PDF at the page number which you stored earlier in GlobalVar:

     Shell "C:\Program Files\Mozilla Firefox\firefox.exe ""file:///C:/My Documents/MyReportName.pdf#page=" & Gpagecount & """"

Screenshot of the result below.

@Kevin, I'm not uploading to a web browser, just want it to open as Print Preview and go to the last page.  How would I modify your code for this?

Hi Sandra, you won't be uploading anything.  A web browser doesn't just open stuff on the Internet; it can also open files such as PDFs stored in your PC.  Instead of opening it in print preview, you open it in the browser.  And it's instantaneous, with the last page shown to you.  So I would think this should serve your purpose just as well.

Keven, I didn't realize you could do that.  I will definitely be giving this a try!  Thanks!