[AccessD] text box in page header

There used to be an example of that kind of report in one of the sample
databases from MS.  If I remember correctly, you used the page footer to
set the page header values on the next page using unbound textboxes in
the page header and bound hidden textboxes in the footer.

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Carolyn
Johnson
Sent: Friday, November 07, 2008 6: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