Can I set the visibility of a field based on a logon?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Employee's enter information about leave time which needs to be viewed by all
staff but not all the particulars such as type of leave. Is there a way to
make "type of leave" field visible to the employee but not to any one else?
Each employee needs the ability to view their own "type of leave" field but
not that of any other employee. Is this possible?
 
Yes. Just set a condition in the form's current event that says...

If CurrentUser() = [UserFielsOnForm]
Then Me.SomeFieldName.Visible = true
Else Me.SomeFieldName.Visible = false
End If



Hope that helps.

Rick B
 
You must log in or register to reply here.

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

Similar Threads

DateDiff past Midnight 8
Access Employee testing checklist 0
Duplicate a set of rows for each item (subdatasheet?) 0
Checkboxes, calculated fields and other fun stuff 1
HR Import for Forecaster 1
Need lookup field on a form- 2007 3
Should I split tables 3
Need help creating a ReportsTo Employee Report 1

Back
Top