How to de idenify a record..

[undefeatedskillz26]

I am trying to do more research on how to take a record (persons address, Social security, etc) and de identify it.

What I am looking to do is if a box is checked that means I can show the records information.

If the box is unchecked each record would have some sort of value like X111111 or something. How would I do this. If i google this for access nothing is coming up, maybe de identify is not the correct word.

I am sure people are doing this for SSN or Credit cards, and want to figure it out just need to know where to go.

Is this something I can do in a Query or something I need to do in the table in VBA? Would be nice if I put the check back in the box the orginal value would come back in case I need the information.

Not sure if this is the best logic, open to ideas. Thanks.

 

[mh123]

On your query you can do something like Cardnumber: Iif(checkbox = checked, cardnumber, "11111111")

This should put you on the right path - good luck and let me know if you get stuck !

 

[MarkK]

You just want to hide certain data in a form, right?

Check out the Current event of the Access.Form object. When a new record is loaded in the form, the current event fires, which you can then handle and take action based on the data in the record, and before the record is displayed. Consider the following code idea . . .

Private Sub Form_Current()
   If Me.HideSensitiveData = True Then
      Me.SensitiveData.Visible = false
   Else
      Me.SensitiveData.Visible = True
   End If
[COLOR="Green"]   'or, more simply put . . .
[/COLOR]   Me.SensitiveData.Visible = Not Me.HideSensitiveData
End Sub

See what's going on there? There are two relevant data points in this record, and based on the value of the one, we hide the other. We do this test for each record as it is loaded in the form, which is when the Current event fires.

And setting the .Visible property is just one option. You can set the Input Mask of the control, or the ControlSource, so change what field is displayed, and so on, and so on,

Hope this helps,