Check boxeand text boxes activated on click

G

Guest

Here's what I've got (Access 2002):

Color (check box)
Color Name (text box)
Color Approval Date (text box)

Color (check box)
Color Approval Date (text box)

Here's what I want: each group of fields to be grayed out until the check
box is clicked. How?
 
T

tina

add code to the checkbox control's AfterUpdate event procedure, as

Me![Color Name].Enabled = Me!Color
Me![Color Approval Date].Enabled = Me!Color

hth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run a form in background using checkboxes on main form 0
Create Check box that controls visibility of a text box or combo b 1
Change color 2
change text box color font on click 2
Need random colors for multiple text boxes on single form 1
Can a Check Box Prevent Other Fields from Being Used? 1
Form shows ID, not values 1
Datasheet check box 3

Top