Hide Duplicates but not on start of new page

  • Thread starter Carma via AccessMonster.com
  • Start date
C

Carma via AccessMonster.com

Hi I have a report like this...

abc 78 fk asdk
asdl
astr
...
<Then start of new page on report>
asdr

But is it possible that on the first line on the start of each page that all
values will show even if they are duplicates?

so like this instead on the start of a new page...
abc 78 fk astr

thanks!
 
M

Marshall Barton

Carma said:
Hi I have a report like this...

abc 78 fk asdk
asdl
astr
...
<Then start of new page on report>
asdr

But is it possible that on the first line on the start of each page that all
values will show even if they are duplicates?

so like this instead on the start of a new page...
abc 78 fk astr


The HideDuplicates feature is pretty limited. Better to use
Sorting and Grouping to create a group header section for
the fields you are hiding. Put those fields in the group
header. To get the group header down on the same line as
the first detail, use a line of code in the group header
section's Format event procedure:
Me.MoveLayout = False
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top