Hide Duplicate Fields on Forms

W

WillW

I'd like to be able to suppress the display of repeating values on a form.
It's simple enough on reports, but can I achieve the same effect on a form
with Default View = Continuous Forms --- and how to do I it?

In Excel, I usually take advantage of conditional formatting for this kind
of thing, but it seems to work differently in Access

Thanks,
Bill
 
J

Jeanette Cunningham

Hi,
the way to do this is to change the recordsource of your form to exclude the
duplicates from showing. If your the recordsource is a query, try using
SELECT DISTINCT instead of just SELECT in the SQL view of the query.

Jeanette Cunningham
 
W

WillW

Thanks Jeanette -- I use DISTINCT, but if my query returns a number of
fields, there are often repeating values in a subset of the returned fields.
These are the ones I'd like to suppress in their display on a form (as you
can easily do in an Access report).
 
J

Jeanette Cunningham

Will,
Access reports are a great feature.
As far as I know, you can't do this on a form unless you use subforms. You
may need a series of subforms.

Jeanette Cunningham
 
Top