Go Back   Access World Forums > Microsoft Access Discussion > Queries

Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 09-15-2019, 10:44 PM   #1
Newly Registered User
Join Date: Aug 2019
Posts: 35
Thanks: 15
Thanked 0 Times in 0 Posts
GoodyGoody is on a distinguished road
What Report level fields are available to the 'On Print' event

Hi, I have a query with a number of columns that aren't printed on the report line but that I was to save to table for each line on the report. In the 'On Print' event I can successfully pick up this particular field (Me.RaceEventID as it happens) from the drop down that appears so Access VBA knows it's in the collection but when I actually run the report VBA gives an error saying it can't field the field Me.RaceEventID. I'd like to know why this is and so is the only work around to 'print' the field on the line but to hide it for printing to to make it explicitly visible to the 'On Print' event? Thanks as usual for any help.

GoodyGoody is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Report Print event? sja13 Modules & VBA 5 12-15-2017 09:38 AM
Graphics - print event in Access report or Excel max1 Reports 4 08-29-2015 09:18 PM
Close Event to Print Report velcrowe General 1 06-30-2006 09:08 AM
Report Event procedures not firing when directly print GumbyD Reports 3 08-17-2004 10:13 AM
Simple code for 'OnLoad' event to print a report nicktheblue Modules & VBA 2 10-19-2001 05:19 AM

All times are GMT -8. The time now is 07:51 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World