Checkbox help again

[Froto]

I'm having a real issue with trying to set the backcolor
of a textbox so that once its checked and the database is
closed and reopened the textbox keeps the color. I have
tried several code but keep getting errors. I have 31
textboxes on a form all have a checkbox inside them so
when a user checks the checkbox or checkboxes on the form
the backcolor should change accordingly. Is there any
straightforward way to accomplish this task with code and
if yes what code would work without errors?

Thanks

 

[Alan Fisher]

-----Original Message-----

I'm having a real issue with trying to set the backcolor
of a textbox so that once its checked and the database is
closed and reopened the textbox keeps the color. I have
tried several code but keep getting errors. I have 31
textboxes on a form all have a checkbox inside them so
when a user checks the checkbox or checkboxes on the form
the backcolor should change accordingly. Is there any
straightforward way to accomplish this task with code and
if yes what code would work without errors?

Thanks
.

Are you storing the value of the check box? If not, you
need to create a yes/no field in the table and store the
value when the user checks it. The code that Bob Rapp gave
you previously should work. It is what I had in mind when
I told you there was a better way than what I suggested.
Reply back if you have more questions