Hide Duplicate Fields on Forms

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

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

"WillW" wrote in message
...
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

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).

"Jeanette Cunningham" wrote:

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

"WillW" wrote in message
...
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

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


"WillW" wrote in message
...
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).

"Jeanette Cunningham" wrote:

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

"WillW" wrote in message
...
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