Continuous forms

  • Thread starter Thread starter Luis
  • Start date Start date
L

Luis

Hello.
I have a continuous forma that i has as recordsource a
table. This table have a Yes/No field and i want that when
the form loads it paints f grey the fields for the records
that have the Yes/No field with Yes.

Is this possible?
 
On a continuous form, your 'enabled' setting applies to all records on the
form, or none. There is no way to do this on a case by case basis. You can
use conditional formatting to simply change the color to gray, but the field
would still be editable.

Rick B


Hello.
I have a continuous forma that i has as recordsource a
table. This table have a Yes/No field and i want that when
the form loads it paints f grey the fields for the records
that have the Yes/No field with Yes.

Is this possible?
 
Click on the field. Select the "Format" menu and then select "Conditional
Formatting...".

Use the "Expression is" condition and enter your expression such as...

[SomeCheckBox]=True

Rick B


And how can i this with conditional formatting?
 
CF exposes the Enabled property for each TextBox control so you can
disable on a row by row basis. THere is a bug in CF though so you must
programmatically manipulate the FormatConditions object rather than
through the CF GUI in order for the Enabled prop setting to stick.
http://www.lebans.com/conditionalformatting.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Back
Top