Conditional Formatting Question

[Kim Wright]

Condition 1, Expression is [Office]="No" & [Status]="On"
Can this Expression be entered as one Condition as I have already used the 2
others,
Thanks, Kim

 

[missinglinq via AccessMonster.com]

You just have to drop the ampersand! The ampersand is used by Access to
concatenate strings!

Expression is [Office]="No" And [Status]="On"

 

[Kim Wright]

Thanks Missinglinq worked just great.....Kim

 

[Kim Wright]

Thanks how can I code this in Conditional Format
=0 and [tbAdditionChargeAmount] has data in it
Thanks Bob

Thanks Missinglinq worked just great.....Kim

You just have to drop the ampersand! The ampersand is used by Access to
concatenate strings!

Expression is [Office]="No" And [Status]="On"

 

[missinglinq via AccessMonster.com]

"=0 and [tbAdditionChargeAmount] has data in it"

I think you need to explain that more clearly.

 

[Kim Wright]

Hi missinglinq
The Conditional Format is to go into TextBoxA
TextBoxA has a value of "0" , TextBoxB has some data in it (Text)
Thank You, Kim

 

[missinglinq via AccessMonster.com]

Hey, Kim! Once again, we use

Expression Is

then

[TextBoxA]="0" And Not IsNull([TextBoxB])