Password Protect One Field on a Form

  • Thread starter Thread starter Susy
  • Start date Start date
S

Susy

Is there a way to limit one particular user for one field
on a form? (I want the boss to be able to give approval
online, but only him.)
Thanks.
 
I think you could do this by setting the field, as
default, to not visible. Then on Form Load or Form
Current, do a VBA check - if user = boss, then field =
visible, else field = not visible.
 
Back
Top