Password a textbox (1 Viewer)

[moose]

i have a form and on this form i have a textbox labeled "Authorised By:"
i want the text box passworded so that the name entered into it must relate to a password to stop unauthorised people trying to put their name in the field.

Is this easy to do?

Is there a better way of doing it

 

[Mile-O]

Set the textbox's InputMask to Password and use its before update event to check (with a DLookup or whatever method you plan on) if the password is allowed. If not , Set Cancel = True, and then do all the stuff that authorised people can do.

 

[moose]

sorry to be a pain, but could you go into detail a bit more as im not to hot on coding

 

[Mile-O]

Where are you holding the passwords? In a table?

 

[moose]

i was going to create a table to store the passwords and restrict the access to it
is this the best way?