Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft Access > Checkboxes affe...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 30603 of 31576
Post > Topic >>

Checkboxes affecting other controls

by zufie <john.marruffo@[EMAIL PROTECTED] > Jun 27, 2008 at 11:57 AM

I have a main form containing 2 checkboxes, ChckIBCCP and
ChckOtherReferral

The respective checkboxes when checked cause the SpecialEffect
Property to make ALL the textboxes to appear Shadowed.

The specific Textboxes and specific Combo Boxes required to appear
Shadowed
are ALMOST the same in number regardless which checkbox is checked.

However, there is one Textbox on the main form that must appear Flat
when ChckIBCCP is
checked, but must appear Shadowed when ChckOtherReferral is checked.

AND However, there are three Textboxes and two Combo Boxes on the main
form that must appear Flat when ChckOtherReferral is checked, but must
appear Shadowed when ChckIBCCP is checked.

1)How how do I cause individual textboxes to appear Flat?

2)How do I cause the Textboxes and Combo Boxes to highlight upon
checking the respective checkbox?

Thanks,

John

Here is my code:


Private Sub ChckIBCCP_Click()
  Dim ctl As Control


  For Each ctl In Me.Controls
    If ctl.Tag = "Shadow1" And ChckIBCCP = True _
    And ctl.ControlType = 109 Then
        ctl.SpecialEffect = 4
    ElseIf ctl.Tag <> "Shadow1" And ctl.ControlType _
    = acTextBox Then
        ctl.SpecialEffect = 1
    End If
  Next
End Sub


Private Sub ChckOtherReferral_Click()
Dim ctl As Control


  For Each ctl In Me.Controls
    If ctl.Tag = "Shadow1" And ChckOtherReferral = True _
    And ctl.ControlType = 109 Then
        ctl.SpecialEffect = 4
    ElseIf ctl.Tag <> "Shadow1" And ctl.ControlType _
    = acTextBox Then
        ctl.SpecialEffect = 1
    End If
  Next


End Sub
 




 1 Posts in Topic:
Checkboxes affecting other controls
zufie <john.marruffo@[  2008-06-27 11:57:52 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Dec 2 23:18:16 CST 2008.