Issues with Continues form

[ducecoop]

Access 2003


Follow up to question I asked ealier
I want to open a continues form :
one of the fields is “ComputerPassword”
Another field is “Privacy”

The on open event has this code:

  Private Sub Form_Open(Cancel As Integer)
   If Me.Privacy = True Then
  Me.ComputerPassword.InputMask = "Password"
   
   End If
  End Sub

Problem is if ANY record has “Privacy” checked then all records get the imput mask?
What am I missing?


tia
Dave

[ajetrumpet]

I believe you're stuck with this when you use that kind of form dave. sorry. consider a split form maybe? but if you're on 03, i guess you can't.

[ducecoop]

Another finding:
It is actually ONLY when the first record is checked for privacy that ALL records get the input mask.
If the first record is NOT checked and any other record is checked NO records get the input mask

I believe you're stuck with this when you use that kind of form dave. sorry. consider a split form maybe? but if you're on 03, i guess you can't.

hmm - not the answer I wanted

I seem to be able to have other effects on a record based upon check boxes in that row (ex:record does not show if Inactive box is checked)

[ajetrumpet]

Another finding:
It is actually ONLY when the first record is checked for privacy that ALL records get the input mask.
If the first record is NOT checked and any other record is checked NO records get the input mask



hmm - not the answer I wanted

I seem to be able to have other effects on a record based upon check boxes in that row (ex:record does not show if Inactive box is checked)

I'm not sure that is correct dave, but I'm pretty sure. if noone else responds here, you might have to dig on your own. c forms use a lot of the same similaries that others do. e.g. - there is a 'current record', etc...

I don't think disappearing a button on a single record in that view is possible. from what I understand, the button is part of the form.