Hide duplicates, instead show something

  • Thread starter Thread starter k0zaw
  • Start date Start date
K

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
 
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
Click to expand...
Click to expand...

Thanks for the reply.

It worked !
 
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
Click to expand...
Click to expand...

Thank!
It totally worked.
 
Back
Top