Password Protect One Field on a Form

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.
 
J

Jennifer Crawford

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top