Mask certain fields in a report using VB

[morlan]

Hi guys. Just wondering if it's possible to hide certain fields in a report with VB.

Here's a screen grab of the report:

The date fields and the 'AppsTaken' fields are duplicated. For Christine Davies, '28/02/2004' and '12apps' is listed 3 times whereas it only needs to be listed once. Is the a way of masking these fields? I can't see any way of forcing the query to suppress these duplicate fields so I though maybe VB could do the job.

Any ideas appreciated.

Here's the design of the report.

 

[uncle-lai]

Hi morlan,

Did you try setting the "Hide Duplicates" Property of those text boxes to Yes?

Peter