[AccessD] text box in page header

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




More information about the AccessD mailing list