A
Andrew Do
I have a subform containing one textbox, such that the
form displays a variable amount of textboxes (depending on
how many to records match the current record in the
form). I would like each textbox to have the color of
its "status" field (either red, blue, yellow, gray, or
green).
Here is an example of my problem: I have 5 textboxes in a
subform, which have statuses of blue, blue, red, green,
and blue respectively. Because the first textbox is blue,
it applies that color to all of the other textboxes in the
subform. When I click on the textbox with "red" status,
it changes all of the textboxes to red, and does similarly
when I click on the green box. Is there a way to be able
to separate the textboxes in the subform, so that I can
dynamically assign colors to each textbox?
Thank you,
Andrew
form displays a variable amount of textboxes (depending on
how many to records match the current record in the
form). I would like each textbox to have the color of
its "status" field (either red, blue, yellow, gray, or
green).
Here is an example of my problem: I have 5 textboxes in a
subform, which have statuses of blue, blue, red, green,
and blue respectively. Because the first textbox is blue,
it applies that color to all of the other textboxes in the
subform. When I click on the textbox with "red" status,
it changes all of the textboxes to red, and does similarly
when I click on the green box. Is there a way to be able
to separate the textboxes in the subform, so that I can
dynamically assign colors to each textbox?
Thank you,
Andrew