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

Stuart McLachlan stuart.mclachlan at gmail.com
Mon Apr 7 08:09:00 CDT 2014


Aircode:

Private strName as string
....

Sub Detail_Format(...)
If FormatCount = 1 
	if me!PersonName = strname then
		myimage.visible = false
	else
		myimage.visible = true
	end if
	strName = me!PersonName
End if	
..
End Sub

On 7 Apr 2014 at 8:59, Susan Harkins wrote:

> 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