Results 1 to 3 of 3
  1. #1
    riverist is offline Novice
    Windows 8 Access 2013
    Join Date
    Feb 2015
    Posts
    3

    How can I remove "Password" input mask from only one record on a datasheet form

    I have a form in datasheet view that has a password field in each record. I used the onClick event in the password textbox to clear "Password" from the input mask property, however this exposes all the passwords on the form. Might there be a way to remove the asterisks and expose the password in only the record I click on?

  2. #2
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    If you want the password in that record to remain visible, then probably not. If you just was to see what the password is, try using a Msgbox the double-click event for the password field to display the value.

    You might be able to do what you want using conditional formatting, where every record except the one you want is shown as white-on-white, otherwise black on white. It still means a user could get the "hidden" passwords with cut-and-paste, though.

  3. #3
    riverist is offline Novice
    Windows 8 Access 2013
    Join Date
    Feb 2015
    Posts
    3
    Using a MSgbox works great. Good idea, thanks John_G.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 09-03-2014, 03:27 AM
  2. Replies: 4
    Last Post: 07-12-2014, 02:02 PM
  3. Replies: 2
    Last Post: 01-15-2014, 07:57 PM
  4. Web Database: Input Mask for Password
    By besuchanko in forum Forms
    Replies: 3
    Last Post: 07-25-2013, 03:28 PM
  5. Replies: 1
    Last Post: 12-28-2012, 02:54 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums