Prev: No Current Record Error
Next: sort by sum of a field
From: wallymeister on 14 Apr 2010 10:57
Is there a way I can know when the detail section of report moves to the
first record of a new group. Something like.....

If Me.DetailSection.BOF Then

I am using Access 2007
Any help is always appreciated.

Thanks,
Wally
From: Marshall Barton on 14 Apr 2010 12:53
wallymeister wrote:

>Is there a way I can know when the detail section of report moves to the
>first record of a new group. Something like.....
>
>If Me.DetailSection.BOF Then
>
>I am using Access 2007


Add a text box to the detail section and set its expression
to =1 and RunningSum property to Over Group. The value of
the text box will be 1 for the first detail in the group.

--
Marsh
MVP [MS Access]
From: wallymeister on 14 Apr 2010 13:41
Thanks Marsh,
That's was too simple. My mind is about fried, I'm ashamed of myself. I
knew that but for some reason I just tried to make it harder than it needs to
be.
Wally

"Marshall Barton" wrote:

> wallymeister wrote:
>
> >Is there a way I can know when the detail section of report moves to the
> >first record of a new group. Something like.....
> >
> >If Me.DetailSection.BOF Then
> >
> >I am using Access 2007
>
>
> Add a text box to the detail section and set its expression
> to =1 and RunningSum property to Over Group. The value of
> the text box will be 1 for the first detail in the group.
>
> --
> Marsh
> MVP [MS Access]
> .
>
 | 
Pages: 1
Prev: No Current Record Error
Next: sort by sum of a field