hide duplicates

[Jologs]

Hi:

How can I hide duplicates in a report when a particular field value change.
Am having a hard time coding it in the report.

The report hide the duplicates in a per column basis not in a per row basis.
How can i go about this. Thanks.

I have txtReference and txtuser in my report. I want to hide to duplicate
of txtreference for the same txtuser. Thanks again.

 

[Allen Browne]

Change the ControlSource of txtReference to:
=IIf([txtReference] = [txtUser], Null, [txtReference])

Change the Name property as well. (Access gets confused if the control has
the same name as a field, but is bound to something else.

 

[Jologs]

Everything was hidden. What I want is to hide the succeeding values only.

Actually, the contents of my details are as follows:

txtUser,txtReference,txtDescription.

what i want is to hide the duplicate values of the txtReference
txtDescription.

Many thanks for your prompt response.

--
Allan - http://allanmagtibay.hostrocket.com

Change the ControlSource of txtReference to:
=IIf([txtReference] = [txtUser], Null, [txtReference])

Change the Name property as well. (Access gets confused if the control has
the same name as a field, but is bound to something else.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

How can I hide duplicates in a report when a particular field value
change.
Am having a hard time coding it in the report.

The report hide the duplicates in a per column basis not in a per row
basis.
How can i go about this. Thanks.

I have txtReference and txtuser in my report. I want to hide to duplicate
of txtreference for the same txtuser. Thanks again.

 

[Allen Browne]

I guess I don't understand what you want to achieve.

You are trying to hide txtReference depending what else is in the same
record. The problem is that Access operates the HideDuplicates property of
the text box based on the previous value in the same column. That means the
HideDuplicates property is useless to you, and you need an expression in a
text box to compare the value of the txtuser field to the txtReference field
in the same record. When the values of the 2 fields are the same, you want
to show nothing in the text box.

Or have I misunderstood you?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Everything was hidden. What I want is to hide the succeeding values only.

Actually, the contents of my details are as follows:

txtUser,txtReference,txtDescription.

what i want is to hide the duplicate values of the txtReference
txtDescription.

Many thanks for your prompt response.

--
Allan - http://allanmagtibay.hostrocket.com

Change the ControlSource of txtReference to:
=IIf([txtReference] = [txtUser], Null, [txtReference])

Change the Name property as well. (Access gets confused if the control
has
the same name as a field, but is bound to something else.

How can I hide duplicates in a report when a particular field value
change.
Am having a hard time coding it in the report.

The report hide the duplicates in a per column basis not in a per row
basis.
How can i go about this. Thanks.

I have txtReference and txtuser in my report. I want to hide to
duplicate
of txtreference for the same txtuser. Thanks again.

 

[Jologs]

You get it right. That's want I want.
--
Allan - http://allanmagtibay.hostrocket.com

I guess I don't understand what you want to achieve.

You are trying to hide txtReference depending what else is in the same
record. The problem is that Access operates the HideDuplicates property of
the text box based on the previous value in the same column. That means the
HideDuplicates property is useless to you, and you need an expression in a
text box to compare the value of the txtuser field to the txtReference field
in the same record. When the values of the 2 fields are the same, you want
to show nothing in the text box.

Or have I misunderstood you?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Everything was hidden. What I want is to hide the succeeding values only.

Actually, the contents of my details are as follows:

txtUser,txtReference,txtDescription.

what i want is to hide the duplicate values of the txtReference
txtDescription.

Many thanks for your prompt response.

--
Allan - http://allanmagtibay.hostrocket.com

Change the ControlSource of txtReference to:
=IIf([txtReference] = [txtUser], Null, [txtReference])

Change the Name property as well. (Access gets confused if the control
has
the same name as a field, but is bound to something else.


How can I hide duplicates in a report when a particular field value
change.
Am having a hard time coding it in the report.

The report hide the duplicates in a per column basis not in a per row
basis.
How can i go about this. Thanks.

I have txtReference and txtuser in my report. I want to hide to
duplicate
of txtreference for the same txtuser. Thanks again.

 

[Allen Browne]

The first reply explains how to do that.

With the ControlSource of txtReference set to:
=IIf([txtReference] = [txtUser], Null, [txtReference])
the box displays nothing if the 2 fields are the same, but the value of
txtReference if not.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

You get it right. That's want I want.
--
Allan - http://allanmagtibay.hostrocket.com

I guess I don't understand what you want to achieve.

You are trying to hide txtReference depending what else is in the same
record. The problem is that Access operates the HideDuplicates property
of
the text box based on the previous value in the same column. That means
the
HideDuplicates property is useless to you, and you need an expression in
a
text box to compare the value of the txtuser field to the txtReference
field
in the same record. When the values of the 2 fields are the same, you
want
to show nothing in the text box.

Or have I misunderstood you?

Everything was hidden. What I want is to hide the succeeding values
only.

Actually, the contents of my details are as follows:

txtUser,txtReference,txtDescription.

what i want is to hide the duplicate values of the txtReference
txtDescription.

Many thanks for your prompt response.

--
Allan - http://allanmagtibay.hostrocket.com


:

Change the ControlSource of txtReference to:
=IIf([txtReference] = [txtUser], Null, [txtReference])

Change the Name property as well. (Access gets confused if the control
has
the same name as a field, but is bound to something else.


How can I hide duplicates in a report when a particular field value
change.
Am having a hard time coding it in the report.

The report hide the duplicates in a per column basis not in a per
row
basis.
How can i go about this. Thanks.

I have txtReference and txtuser in my report. I want to hide to
duplicate
of txtreference for the same txtuser. Thanks again.