Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Oct 2001
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Masking all digits except last 4 in SSN (Excel 2000)

    You could try this within a query:

    CInt(Right([SSN],Len([SSN])-5))

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Masking all digits except last 4 in SSN (Excel 2000)

    Or use <code>Right([SSN],4)</code> where SSN is the name of the field.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Masking all digits except last 4 in SSN (Excel 2000)

    Thank you both very much. That will work for now. Had thought about it for the Input Mask on the table field, but a query result is a possibility with a few modifications to the switchboard. Instead of showing a Read-only table, the query results could be shown instead.
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Masking all digits except last 4 in SSN (Excel 2000)

    An Input Mask is used to guide input in a field or control, it can't be used to hide part of a field.

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Masking all digits except last 4 in SSN (Excel 2000)

    Understood. I knew you could use PASSWORD to hide all the contents...just wasn't sure about parts of a field...with Access, I've learned over time to think, "where there is a will there is a way"...but on occassion learn that is not true. The query will be fine. Thank you Hans
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  6. #6
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Masking all digits except last 4 in SSN (Acce2000)

    Is there a way to mask or hide the first 5 digits of a social and only show the last 4 in a field?
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •