If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Level break events
Can anyone help me with this? I have a report which contains a level break
on the customer field at which time a new page is started. Is there an event that fires on level breaks where I can cause some of the controls on the report to be invisible only on the first page of each customer's information? Thanks in advance -- Glenn |
#2
|
|||
|
|||
Glenn Suggs wrote:
Can anyone help me with this? I have a report which contains a level break on the customer field at which time a new page is started. Is there an event that fires on level breaks where I can cause some of the controls on the report to be invisible only on the first page of each customer's information? The Group header section's Format event cam be used to make them invisible. Not sure where you want to make them visible again, perhaps the detail section's Format event? -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
Thanks for the reply, Marshall. I thought that was going to work for a
minute. But I need the page header controls to disappear at the top of every page that starts a new customer and putting the code in the group header format event turned them off AFTER the page header was already printed. The detail format event apparently turned them back on for the second page but I'm still back where I was with the controls printing on top of the first customer page. Is there no place to turn them off say, before a page break? Thanks again, Glenn "Marshall Barton" wrote: Glenn Suggs wrote: Can anyone help me with this? I have a report which contains a level break on the customer field at which time a new page is started. Is there an event that fires on level breaks where I can cause some of the controls on the report to be invisible only on the first page of each customer's information? The Group header section's Format event cam be used to make them invisible. Not sure where you want to make them visible again, perhaps the detail section's Format event? -- Marsh MVP [MS Access] |
#4
|
|||
|
|||
Ahhh, the controls are in the page header. In that case,
try making them invisible in the Report header Format event (for the first group) AND in the group footer's format event (for the next group). In this case, the group header is probably the best place to make them visible again. -- Marsh MVP [MS Access] Glenn Suggs wrote: Thanks for the reply, Marshall. I thought that was going to work for a minute. But I need the page header controls to disappear at the top of every page that starts a new customer and putting the code in the group header format event turned them off AFTER the page header was already printed. The detail format event apparently turned them back on for the second page but I'm still back where I was with the controls printing on top of the first customer page. Is there no place to turn them off say, before a page break? Glenn Suggs wrote: Can anyone help me with this? I have a report which contains a level break on the customer field at which time a new page is started. Is there an event that fires on level breaks where I can cause some of the controls on the report to be invisible only on the first page of each customer's information? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to create a Multi Level List | Perra Thomsson | Database Design | 4 | January 16th, 2005 05:27 PM |
Finding/removing an "obascure" manual page break | Fred Holmes | Tables | 2 | November 5th, 2004 06:57 PM |
Section Break in Word 2003 | Kathryn M | Page Layout | 2 | September 19th, 2004 12:21 AM |
Group events | Sam Hobbs | Setting Up & Running Reports | 5 | September 17th, 2004 05:23 AM |
Best way to change they type of a section break? | Jeff Heikkinen | General Discussion | 1 | August 22nd, 2004 05:57 PM |