Change one column on continuous form

[Ron Carr]

I want to change the forecolor on one column in one row of a continuous form.
When i change it, that column changes on all rows in the form.
Is there a way to restrict the change to the one row I want?

Ron

 

[ruralguy via AccessMonster.com]

If the column is a TextBox bound to a field in the underlying table/query and
you are using ac2k+ then Conditional Formatting will work.

 

[Ron Carr]

I had forgotten that...but...I would like the color change to be based on the
content of another field, a Boolean that tells me to make the change. This
field is NOT displayed.

 

[ruralguy via AccessMonster.com]

Display it but put it behind one of your other control and make it small and
not visible. You can still use it in your conditional statement.

I had forgotten that...but...I would like the color change to be based on the
content of another field, a Boolean that tells me to make the change. This
field is NOT displayed.

If the column is a TextBox bound to a field in the underlying table/query and
you are using ac2k+ then Conditional Formatting will work.

[quoted text clipped - 4 lines]

 

[Ron Carr]

I must be missing something here. If I define field A as a boolean and field
B as the field I want to display and change color depending on field A:
field A is on the continuous form but not visible
field B is on the continuous form and visible

I cannot apply Conditional Formatting to field B based on a value in field A
It does no good to set Conditional Formatting on field A if it is not visible

Am I missing something in your explanation?
Thanks for your attention....

Display it but put it behind one of your other control and make it small and
not visible. You can still use it in your conditional statement.

I had forgotten that...but...I would like the color change to be based on the
content of another field, a Boolean that tells me to make the change. This
field is NOT displayed.

If the column is a TextBox bound to a field in the underlying table/query and
you are using ac2k+ then Conditional Formatting will work.

[quoted text clipped - 4 lines]

Ron

 

[ruralguy via AccessMonster.com]

The Conditional Format is on ControlB (FieldB).

Condition 1 = Expression Is

ControlA = True
or
FieldA = True

I must be missing something here. If I define field A as a boolean and field
B as the field I want to display and change color depending on field A:
field A is on the continuous form but not visible
field B is on the continuous form and visible

I cannot apply Conditional Formatting to field B based on a value in field A
It does no good to set Conditional Formatting on field A if it is not visible

Am I missing something in your explanation?
Thanks for your attention....

Display it but put it behind one of your other control and make it small and
not visible. You can still use it in your conditional statement.

[quoted text clipped - 8 lines]