Using Conditional Formatting, evalaute the state of the field bound to the
CheckBox to set the Background color of the TextBox to match that of the
Background color of the form. You might have to set the Disabled prop via CF
as well.
There is sample code showing one wat to accomplish this here:
http://www.lebans.com/conditionalformatting.htm
A2K or Higher Only!
New Feb 08,2002. Added support for Datasheet view and SubForms.
A2KConditionalFormatting.zip is a sample MDB demonstrating how to
programmatically setup Conditional Formatting to simulate:
1) Highlighting of the Current Row for a Form in Continuous or Datasheet
View
2) Highlighting of Alternate Rows for a Form in Continuous or Datasheet View
Version 2.7
Added sample demonstrating how to achieve a background Hover/Highlighting of
rows for a form in Continuous view.
Version 2.3
Added sample demonstrating how to achieve pseudo enable/disable of an
unbound control on a form in Continuous View.
Version 1.9
Added sample form to show how to apply conditional formatting to based on a
Boolean(Yes/No) field.
--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.