Rocky Smolin
rockysmolin at bchacc.com
Mon Apr 7 14:22:48 CDT 2014
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