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

Stuart McLachlan stuart at lexacorp.com.pg
Mon Apr 7 15:58:54 CDT 2014


There is in 2007/2010 - but it is only effective in the new "Report" view when you click on a 
row  - not in "Print Preview" or when printing.

-- 
Stuart

On 7 Apr 2014 at 12:22, Rocky Smolin wrote:

> There's no Current event like a form in reports but there is
> Detail_Format and Detail_Print.
> 
> r 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bill Benson
> Sent: Monday, April 07, 2014 12:56 PM To: 'Access Developers
> discussion and problem solving' Subject: Re: [AccessD] Fwd: Report's
> Hide Duplicate property doesn't workwithall field types?
> 
> 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
> 
> --
> 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