A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Level break events



 
 
Thread Tools Display Modes
  #1  
Old February 22nd, 2005, 07:19 PM
Glenn Suggs
external usenet poster
 
Posts: n/a
Default 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  
Old February 22nd, 2005, 11:39 PM
Marshall Barton
external usenet poster
 
Posts: n/a
Default

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  
Old February 23rd, 2005, 01:49 AM
Glenn Suggs
external usenet poster
 
Posts: n/a
Default

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  
Old February 23rd, 2005, 04:36 AM
Marshall Barton
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 05:40 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.