Showing field after page 1
in [Reports]
|
Prev: Need help: table with all locations AND just one location
Next: Export MS Access report to single html
From: Don on 12 May 2010 17:41 Hello, I have an Access 2003 report that show several fields on the top of the first page (one of thses fields is the WorkOrderID), these fields are in a "WorkOrderID" header. The work order details can span several pages, on the 2nd, 3rd, etc pages I just want to show the WorkOrderID and not the other fields that show on the first page. Can I somehow put the WorkOrderID field in the PageHeader but tell it not to show on the first page? Thanks
From: fredg on 12 May 2010 18:27 On Wed, 12 May 2010 14:41:00 -0700, Don wrote: > Hello, I have an Access 2003 report that show several fields on the top of > the first page (one of thses fields is the WorkOrderID), these fields are in > a "WorkOrderID" header. The work order details can span several pages, on > the 2nd, 3rd, etc pages I just want to show the WorkOrderID and not the other > fields that show on the first page. Can I somehow put the WorkOrderID field > in the PageHeader but tell it not to show on the first page? > > Thanks Code the Page Header's Format event: Me.[WorkOrderID].Visible = Me.[Page] > 1 -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
From: Marshall Barton on 12 May 2010 18:30
Don wrote: >Hello, I have an Access 2003 report that show several fields on the top of >the first page (one of thses fields is the WorkOrderID), these fields are in >a "WorkOrderID" header. The work order details can span several pages, on >the 2nd, 3rd, etc pages I just want to show the WorkOrderID and not the other >fields that show on the first page. Can I somehow put the WorkOrderID field >in the PageHeader but tell it not to show on the first page? Add a line of VBA code to the Page Header section's Format event procedure: Me.txtWorkOrderID.Visible = (Me.Page > 1) -- Marsh MVP [MS Access] |