Restrictive access on specific column in table form

[akhlaq768]

I have a form in MS Access and want to add another column at the end of my student list called 'Notes'

As this field will contain sensitive and private information, can it be restricted access to specific named staff?

 

[pr2-eugin]

How are you providing access to the form to the users? If you are using a Login Form of some kind, maybe use that information and make the column in the form to set as visible.

'If authorised user:
columnName.Visible=True
'Else
columnName.Visible=False

Or also another way to implement is to create an authorisation window, (something like a password prompt box), on click property of the notes field; call the password box. If the password is right, show details, else display an error.