Passworded Field

  • Thread starter Thread starter bob engler
  • Start date Start date
B

bob engler

I have a form that has credit card and check data in several fields. Is
there
a way to put some on those fields that would only show the data if the user
was entitled to see it?

Thanks....
 
Hi Bob,

in the form OnCurrent event (and AfterUpdate event of the
control that determines if they are entitled if applicable)

'~~~~~~~~~~~~
If YOURCONDITION_forEntitled Then
Me.controlname.InputMask = ""
'or other InputMask
Else
Me.controlname.InputMask = "Password"
End If
'~~~~~~~~~~~~

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
 

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

Setting the Focus on a Specific Field after clicking "Add Record" 2
Copy data of some fields on a form to the next record 3
Form Field Questions 2
Password encryption 2
Sub form validations 4
Can a Check Box Prevent Other Fields from Being Used? 1
Access Form - Lock Fields from Editing 0
Conditional Formatting in Combo Box (ACC2007) 2

Back
Top