shade the first row

[RayNDM83]

Hi,
I have a report where the first field will be identical to two or more rows.
The rows are formatted in accessending order by the first field with
duplicates. Is there a way to shade the first row of the duplicates?
Many thanks,
RayNDM83

 

[Duane Hookom]

Could you take the time to type in a few records as would appear in the
report and indicate which row(s) should be shaded.

 

[Marshall Barton]

I have a report where the first field will be identical to two or more rows.
The rows are formatted in accessending order by the first field with
duplicates. Is there a way to shade the first row of the duplicates?

You might want to explare using the first control's
HideDuplicates property instead.

If you really need to color the first record in a group,
then Use Sorting and Grouping (View menu) to create a group
header section on the first field, Set the group header
section's Height to the detail Height and set its BackColor
to whatever you like. Then add a line of code to the group
header section Format event:
Me.MoveLayout = False