Hide Field on rows (1 Viewer)

[pekajo]

Hi,
How do I hide a row field based on another field in the row.
When the field has "Team Leader" I need to make visible and hide the [P] button on all the others.
Thanks for any help.
Peter
Please see te

 

[isladogs]

You can use conditional formatting to disable controls but not to hide them.
To do that will require vba.

 

[vba_php]

How do I hide a row field based on another field in the row.
When the field has "Team Leader" I need to make visible and hide the [P] button on all the others.

Peter,

Your picture looks like you're using a continuous form. If you are, you can't do what you want because each row is a *record* and every control you see on every row is the same control in reality. It's just repeated time after time after time. So, if you make it disappear using a property like .visible, you won't see it *anywhere* on the screen, in any row. if you want to do what you're thinking you're going to have to switch the form view to "normal" or "single form". if you do that, you can add code to manipulate the .visible property of your "P" button based on the data of the record you are viewing.