View Single Post
  #3  
Old November 24th, 2005, 01:57 AM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Print to Header, Not Detail

On Wed, 23 Nov 2005 17:47:35 -0700, bw wrote:

I'd like to print the first record of a group to the Page or Group header,
but not print that record again in the detail section.

How's it done?
Thanks,
Bernie


Place your controls in the Page header.

Add an unbound control to the detail section.
Name it Show.
You can make it not visible.

Code the Page Header Format event:
Me![Show] = 1

Code the Detail Format event:
Cancel = Me![Show] = 1
Me![Show] = 2

That should do it for you.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail