Conditional Formating problem

[NeilK]

Hi,

I know this should be easy but I can't get it to work. I want to add a conditional format to a report field based on an expression that evaluates two conditions:

([txtCriteria1].[Text]="") And ([txtTypeNum].[Text]=1)

I'm sure this is just a case of syntax. Should I reference the recordset instead of the report fields?


Thanks for your help!

Neil

 

[Smart]

Select the field you want to apply the conditional format to then from the condition drop down box select expression is

then type the following in the adjacent box

[txtCriteria1].[Text]="" And [txtTypeNum].[Text]=1

 

[NeilK]

still having problems

Select the field you want to apply the conditional format to then from the condition drop down box select expression is

then type the following in the adjacent box

[txtCriteria1].[Text]="" And [txtTypeNum].[Text]=1

This isn't working for me. I know there is data matching the conditions but the format is not being applied. 'txtCriteria1' and 'txtTypeNum' are the names of controls, not query fields.

I have some overlapping controls and it may be getting confused. I have used the 'send to front' option to ensure that the control I want to see should be appearing.

Any other ideas?

 

[Smart]

can you post a copy of your DB to have a look at ?

 

[NeilK]

Unfortunately I can't do that. Confidentiality and all...

 

[Laurentech]

I think what you'll probably need to do is in the onformat event of the report section put an if/then such as:

If me.txtCriteria1="" And me.txtTypeNum=1 then

do some formatting here like changing colors or fonts or whatever

end if


Larry