Hide duplicates, instead show something

[k0zaw]

Hello,
Is it possible to hide duplicates in a control (lets say a textboxA)
but instead I want to show something like "(same as above)" in that
control.
Overlapping a label under textboxA doesn't look good when I exporting
to rtf.
Thanks in advance for your responses.
....
k0zaw

 

[Allen Browne]

Add another text box that test the IsVisible property of the text box where
you HideDuplicates.

Something like this:
=IIf([Text0].IsVisible, [Text0], "(same as above)")

More info and example:
http://allenbrowne.com/casu-21.html

 

[Kozaw]

Add another text box that test the IsVisible property of the text box where
you HideDuplicates.

Something like this:
    =IIf([Text0].IsVisible, [Text0], "(same as above)")

More info and example:
   http://allenbrowne.com/casu-21.html

--
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

Hello,
Is it possible to hide duplicates in a control (lets say a textboxA)
but instead I want to show something like "(same as above)" in that
control.
Overlapping a label under textboxA doesn't look good when I exporting
to rtf.
Thanks in advance for your responses.
...
k0zaw

Thanks for the reply.

It worked !

 

[k0zaw]

Add another text box that test the IsVisible property of the text box where
you HideDuplicates.

Something like this:
    =IIf([Text0].IsVisible, [Text0], "(same as above)")

More info and example:
   http://allenbrowne.com/casu-21.html

--
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

Hello,
Is it possible to hide duplicates in a control (lets say a textboxA)
but instead I want to show something like "(same as above)" in that
control.
Overlapping a label under textboxA doesn't look good when I exporting
to rtf.
Thanks in advance for your responses.
...
k0zaw

Thank!
It totally worked.