hiding duplicates

[randria]

Hi, is there a way of hiding duplicated data in a continuous form or
Datasheet ? For example:
Date Time Prg
18-02-09 09:00 xyz
18-02-09 10:00 abc
(to hide the date of the second line)

Many thanks.

 

[Tom van Stiphout]

On Wed, 18 Feb 2009 01:42:01 -0800, randria

This built-in option exists in reports (HideDuplicates) but not in
forms.
One reason may be that datasheets can easily be resorted (e.g. sort by
Prg) and then different values may need to be hidden.

-Tom.
Microsoft Access MVP

 

[randria]

Thanks for your reply, would conditional formatting do it ? Let s say if the
value of date control (afterupdate) is equal to the previous value then
change font to white(like background). I have been trying to figure this out
but I dont know how to start. Or it is not worthwhile ?

 

[Tom van Stiphout]

On Wed, 18 Feb 2009 06:26:08 -0800, randria

I haven't used Conditional Formatting too much, but mostly it is used
to look at the values of the CURRENT row and display things
accordingly. I think it would be quite a challenge to make it look at
the PREVIOUS record to decide what to do.

-Tom.
Microsoft Access MVP