Jim Dettman
jimdettman at verizon.net
Sat Nov 8 14:00:22 CST 2008
Carolyn, Try setting the force new page property to none for the Event ID footer and Before section for the force new page property on the header. If that doesn't work, then you'll probably need to make it a two pass report. You'd pickup and store the info for each page on the first pass, then push it to unbound text controls on the second to show the correct info. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Carolyn Johnson Sent: Friday, November 07, 2008 9:49 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] text box in page header The report is a catalog with 2 main groups of records - field name EventType. Each group then has several subgroups. I want the page header to show the value of EventType, along with the date. There is an EventType footer with the force new page property set to After Section. On the first page for the second EventType, the page header text box EventType still has the old value. It's not until the EventType header section that the value changes. If I put the controls I want to print on each page into the EventType header with RepeatSection = true, I get the desired effect -- the EventyType and Date print at the top of each page -- EXCEPT on the page where the new group starts, the text boxes print twice, the first time with the old values and the second time with the new group's values. Thanks Carolyn Johnson ----- Original Message ----- From: "Susan Harkins" <ssharkins at gmail.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Friday, November 07, 2008 8:39 PM Subject: Re: [AccessD] text box in page header > Is there just one group per page -- you mentioned wanting it in the > header -- do you mean the page header or the group header? > > Susan H. > > >> It comes from a value in the group. >> >> Carolyn Johnson >> >>> Does the header value come from a value in the group or are you just >>> sequentially numbering them? >>> >>>> Access2003, WinXP >>>> >>>> I have a text box in the page header of a report that changes values as >>>> the >>>> records move from one group to another. This text box on the first >>>> page >>>> of >>>> "group 2" still has the value for "group 1". Is there a way to get >>>> the >>>> correct value for a new group level in this text box, or do I have to >>>> move >>>> text box to the group header section? >>> >>> -- >>> AccessD mailing list >>> AccessD at databaseadvisors.com >>> http://databaseadvisors.com/mailman/listinfo/accessd >>> Website: http://www.databaseadvisors.com >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com