Report/Form formatting

[Bill]

I asked this question on the formscoding NG
but perhaps it's better posted here?

Shouldn't this conditional formatting work? (CF
applied to a text box on a form.)

1st cond: Expression is --- [Missing]=True Red
2nd cond: Expression is --- [Deceased]=True Blue

Only the second of the two specifications takes effect.
If I reverse them, once again it's only the 2nd spec that
effects display.

 

[Jeff Boyce]

Bill

I'm not sure I follow how a "forms"-related question belongs in a "reports"
newsgroup...

Are you using conditional formatting on two separate controls (e.g.,
[Missing] and [Deceased])?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Bill]

Jeff,

I just posted here in the belief that there might be
more experience with conditional formatting on
report controls that would also apply to forms.

There are two text box controls on my continuous
form: last name and first name. Each of those two
controls have the conditional formatting specifications:

cond 1: Expression is --- [Missing]=True Red
cond 2: Expression is --- [Deceased]=True Blue

Thus, if the current record has the "missing" field
true, then change the foreground color to red. If
the "deceased" field is true, then change the fore-
color to blue.

No matter what order the conditions are specified,
it is only the second that has any effect. It's as though
the first condition didn't exist at all.

Bill

Bill

I'm not sure I follow how a "forms"-related question belongs in a
"reports" newsgroup...

Are you using conditional formatting on two separate controls (e.g.,
[Missing] and [Deceased])?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I asked this question on the formscoding NG
but perhaps it's better posted here?

Shouldn't this conditional formatting work? (CF
applied to a text box on a form.)

1st cond: Expression is --- [Missing]=True Red
2nd cond: Expression is --- [Deceased]=True Blue

Only the second of the two specifications takes effect.
If I reverse them, once again it's only the 2nd spec that
effects display.

 

[Bill]

I applied the exact same conditional formatting
on a comparable Report and the formatting is
perfect.

I'll re-post on the Forms NG for assistance.

Bill

 

[Jeff Boyce]

"Continuous form" may not be what you want to use because of the issue with
conditional formatting. Instead, create a "single form" that looks like a
row (in a continuous form), then expand the size of the window to show
several "rows".

Your conditional formatting should work in this environment.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff,

I just posted here in the belief that there might be
more experience with conditional formatting on
report controls that would also apply to forms.

There are two text box controls on my continuous
form: last name and first name. Each of those two
controls have the conditional formatting specifications:

cond 1: Expression is --- [Missing]=True Red
cond 2: Expression is --- [Deceased]=True Blue

Thus, if the current record has the "missing" field
true, then change the foreground color to red. If
the "deceased" field is true, then change the fore-
color to blue.

No matter what order the conditions are specified,
it is only the second that has any effect. It's as though
the first condition didn't exist at all.

Bill

Bill

I'm not sure I follow how a "forms"-related question belongs in a
"reports" newsgroup...

Are you using conditional formatting on two separate controls (e.g.,
[Missing] and [Deceased])?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I asked this question on the formscoding NG
but perhaps it's better posted here?

Shouldn't this conditional formatting work? (CF
applied to a text box on a form.)

1st cond: Expression is --- [Missing]=True Red
2nd cond: Expression is --- [Deceased]=True Blue

Only the second of the two specifications takes effect.
If I reverse them, once again it's only the 2nd spec that
effects display.

 

[Bill]

This problem went away as mysteriously as it
appeared. The conditional formatting was
deleted and re-added exactly as was done
originally. The ONLY difference was that
I just happened to add the CF while in form
view rather than Design View, something I'd
never done in the past.

Go figure.

Bill

"Continuous form" may not be what you want to use because of the issue
with conditional formatting. Instead, create a "single form" that looks
like a row (in a continuous form), then expand the size of the window to
show several "rows".

Your conditional formatting should work in this environment.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff,

I just posted here in the belief that there might be
more experience with conditional formatting on
report controls that would also apply to forms.

There are two text box controls on my continuous
form: last name and first name. Each of those two
controls have the conditional formatting specifications:

cond 1: Expression is --- [Missing]=True Red
cond 2: Expression is --- [Deceased]=True Blue

Thus, if the current record has the "missing" field
true, then change the foreground color to red. If
the "deceased" field is true, then change the fore-
color to blue.

No matter what order the conditions are specified,
it is only the second that has any effect. It's as though
the first condition didn't exist at all.

Bill

Bill

I'm not sure I follow how a "forms"-related question belongs in a
"reports" newsgroup...

Are you using conditional formatting on two separate controls (e.g.,
[Missing] and [Deceased])?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I asked this question on the formscoding NG
but perhaps it's better posted here?

Shouldn't this conditional formatting work? (CF
applied to a text box on a form.)

1st cond: Expression is --- [Missing]=True Red
2nd cond: Expression is --- [Deceased]=True Blue

Only the second of the two specifications takes effect.
If I reverse them, once again it's only the 2nd spec that
effects display.