Change one column on continuous form

[Guest]

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.

 

[Guest]

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]

 

[Guest]

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

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com

 

[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]