Show Field for First Record in Group Only

[Simon Shutter]

Hi Folks,

I want to add a header field to each group of records on a report. Normally
I can just create a header for that field but in this case I want to have
the header adjacent to the first record of the group and not above the
group.

My solution was to add two text boxes (txt1 and txt2) associated with a
numeric field common to the group. For txt1 I set the Running Sum property
to Over Group. I made both text boxes invisible since they were not needed
in the report output. Then I set the conditional formatting property of the
header field to Expression Is txt1.value <> txt2.value and the font color
to white. This has the following effect

header field txt1 txt2
xxxx (black) 1 1
xxxx (white) 2 2
xxxx (white) 6 3

Is there an easier, elegant way to do this?

Tx, Simon

 

[Duane Hookom]

I would make sure the header section and detail section are the same height.
Remove the extra control from the detail section. Then add code to the
Header Section On Format event:
Me.MoveLayout = False

 

[Simon Shutter]

Thanks, Duane - I'll try that

I would make sure the header section and detail section are the same
height. Remove the extra control from the detail section. Then add code to
the Header Section On Format event:
Me.MoveLayout = False

 

[Simon Shutter]

Duane et al,

Great tip - is there an equivalent method for putting a footer field
adjacent to the last record in the details section?

Tx

 

[Duane Hookom]

There is a reply to this in a later message that you posted in this group.