conditional formatting

[Jcraig713]

I am so happy I found this forum! I have learned so much through readig
everyone's postings and responses. Anyhow, I hope someone can answer my
question...

I have a form created to house student records. I have 18 seperate fields on
my form (including a field for active / inactive that indicates if a student
is of course active or inactive) I would like all 18 fields to appear in bold
and red when the status field indicates inactive. Can anyone explain how or
if I can do this?

Thanks in advance for your time.

 

[schasteen]

Open the form in design view, select a control, from the menu select format,
then conditiional formatting, change the condition to Expression is, enter
your expersion (ex: [active_inavctive] = "Inactive") and the set the format
you want. You can then use the format painter to put the same conditional
format on all the other controls.

 

[Jcraig713]

That is so cool! Thanks for your suggestions!

Open the form in design view, select a control, from the menu select format,
then conditiional formatting, change the condition to Expression is, enter
your expersion (ex: [active_inavctive] = "Inactive") and the set the format
you want. You can then use the format painter to put the same conditional
format on all the other controls.

I am so happy I found this forum! I have learned so much through readig
everyone's postings and responses. Anyhow, I hope someone can answer my
question...

I have a form created to house student records. I have 18 seperate fields on
my form (including a field for active / inactive that indicates if a student
is of course active or inactive) I would like all 18 fields to appear in bold
and red when the status field indicates inactive. Can anyone explain how or
if I can do this?

Thanks in advance for your time.

 

[schasteen]

No problem. It is the same for reports also.

That is so cool! Thanks for your suggestions!

Open the form in design view, select a control, from the menu select format,
then conditiional formatting, change the condition to Expression is, enter
your expersion (ex: [active_inavctive] = "Inactive") and the set the format
you want. You can then use the format painter to put the same conditional
format on all the other controls.

I am so happy I found this forum! I have learned so much through readig
everyone's postings and responses. Anyhow, I hope someone can answer my
question...

I have a form created to house student records. I have 18 seperate fields on
my form (including a field for active / inactive that indicates if a student
is of course active or inactive) I would like all 18 fields to appear in bold
and red when the status field indicates inactive. Can anyone explain how or
if I can do this?

Thanks in advance for your time.