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

C

cromanik

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?
 
R

Rick B

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
 
Top