[AccessD] Fwd: Report's Hide Duplicate property doesn't work withall field types?

Bill Benson bensonforums at gmail.com
Mon Apr 7 14:56:07 CDT 2014


I haven't programmed in Access reports in a long, long, long time.

But if you used that command in the Current event, won't it affect only one
record at a time?

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Monday, April 07, 2014 8:59 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Fwd: Report's Hide Duplicate property doesn't work
withall field types?

Wouldn't that hide them all instead of just the duplicates? He wants to see
the first occurrence.

Susan H.


On Mon, Apr 7, 2014 at 8:56 AM, Rocky Smolin <rockysmolin at bchacc.com> wrote:

> Or (control name).visible=false?
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
> Sent: Monday, April 07, 2014 5:38 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Fwd: Report's Hide Duplicate property doesn't work
> withall field types?
>
> Quick check and it appears to be true. The Attachment field doesn't offer
> the Hide Duplicates property. Hmmm.... the only alternative that seems
> reasonable is a subreport.
>
> Susan H.
>
>
> A reader recently wrote to me about the Report object's Hide Duplicate
> property. It worked fine on the query's primary key field -- a name. But
> the
> query also includes the person's picture, and that's being repeated for
> each
> record. She claims the Hide property isn't available. I haven't tested
this
> yet, but thought I'd see if anyone else had run into this and what you
did?
>
> SUsan H.
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list