Text box change color

[Ray67]

Hello

I have two check boxes on a form. I would like to force the user to pick one of the check boxes. Once the user picks the check box, it would change the color for some of the text box and required them to only fill in those text box that change color.

Thank you,

[June7]

Are these checkboxes each bound to a field? If only one check is allowed then this should be one field. Use radio buttons in an OptionGroup control and only one can be selected. Bind the OptionGroup control to the field.

Use Conditional Formatting to control backcolor of the textboxes.

Is this form in Single view? Instead of just changing color, could use code to disable or make invisible textboxes that should not be used.

[Ray67]

June7

I like your idea making textboxes invisible. It is a single form view. Can you guide me how to do this????


Thank You

[June7]

In checkbox click event, VBA code something like:

Me.textboxname.Visible = Me.checkboxname

[Ray67]

Which event should i pick???

[June7]

Wait, are you still using two checkboxes or did you change to a single field and one checkbox or radio buttons in option group?

[Ray67]

I'm using two checkboxes

[June7]

So can both checkboxes be checked at the same time? Why two checkboxes? Each checkbox will manage different controls?

As suggested earlier (post 4), try the checkbox click event.

[Ray67]

Both checkboxes can not be checked off at the same time. Some textbox would be need for both check box. Example patient name would be needed for both.

[Ray67]

I forgot to mention that i also have a subform.

[June7]

What prevents user from checking both checkboxes?

The checkboxes are on main form and controls to be managed are in subform?

[Ray67]

Check box one is Check and check box two is credit card. So for each check box the user would enter different inforamion. Some of the controls are on the main form and some on the subform.

Table One:Patient Demographics (Form One)
Table Two: Refund Request (Form Two)

[June7]

Still don't know what prevents user from checking both checkboxes. Still seems to me should be one field bound to option group holding 2 radio buttons.

I always give subform container control a name different from the object it holds, like ctrDetails. Then reference to subform controls like:

Me.ctrDetails.Form.controlname1.Visible = Me.checkboxname
Me.ctrDetails.Form.controlname2.Visible = Not Me.checkbaxname

[Ray67]

Can i put something to prevent user from checking both checkboxes. Lets go with radio buttons. On post 2 you suggested to use radio buttons but i'm not sure how to go about this.

[June7]

Can i put something to prevent user from checking both checkboxes.
That would be complicated, maybe impossible.

If you use option group and radio buttons (AKA Option Buttons, need one field instead of 2, review http://office.microsoft.com/en-us/ac...005188325.aspx

Checkboxes and toggle buttons can also be in option group but radio button makes most sense to me.