Gray Out Form Fields

R

Rhett_Y

Hi all...

Is there a way of doing this:

On a form.. Person has a yes/no checkbox. Below the check box the fields
are locked so they cannot enter anything. If they put a check in the check
box I would like the other fields below it to become editable. Does this
make sense?? Is this even possible in access?

Thanks
R~
 
F

freakazeud

Hi,
sure...just add code to the after update event of the checkbox e.g.:

If Me.Checkbox = True Then
Me.YourControl01.Enabled = True
Me.YourControl02.Enabled = True
Me.YourControl03.Enabled = True
Else
Me.YourControl01.Enabled = False
Me.YourControl02.Enabled = False
Me.YourControl03.Enabled = False
End If

BTW...forms hold controls...fields are in tables.
HTH
Good luck
 
R

Rhett_Y

Freakazeud...

Thanks a bunch I will try it out and post back.....

Thanks again
R~
 
F

freakazeud

You're welcome.
You could also directly evaluate the boolean value with the enabled property
instead of using an if then else statement. You would toggle two boolean
values in that case e.g.:

Me.YourControl01.Enabled = Me.CheckboxControl
Me.YourControl02.Enabled = Me.CheckboxControl
....
You can do this on the on current event of the form!
Good luck
 
R

Rhett_Y

Hello again..

I haven't tried the second method.. yet.. The first one works fine
except.. I have to check the box first then uncheck it and then the boxes
will go gray. Is there any way to make it gray until you put a check in the
box?

Thanks
R~
 
R

Rhett_Y

Ok.. I tried the second method and it is doing the same thing. Is there
something I need to switch to tell it to be in the "no" position? That would
cause the grayed out fields to be grayed out right of the bat?

Thanks again
Rhett
 
R

Rhett_Y

And if so.. where does it go???

Thanks
R~

Rhett_Y said:
Ok.. I tried the second method and it is doing the same thing. Is there
something I need to switch to tell it to be in the "no" position? That would
cause the grayed out fields to be grayed out right of the bat?

Thanks again
Rhett
Click to expand...
 
R

Rhett_Y

Hi all..

I figured it out.. I had to make the box/field disabled.... then used the
code above so now it is grayed out until you check the check box....

Freak...

Thanks for the code mucho appreciated!!!!!!

R~
 
Top