emk
07-13-2009, 01:51 PM
Hi,
I'm trying to set some conditional formatting in an Access report. I have seven columns on the report and the conditional formatting is based on whether or not a field is set to "Yes" or "No". If the field is set to "Yes", then the whole row is supposed to bold and highlight yellow. Is set up the condition as an expression and it works fine for the bold, but not for the highlight. When the field is "Yes" it is bolding the entire row, but it is only highlighting one column in the row. The only difference I see in the columns is that the one that is being highligted is not a formula; all the other columns are based on a formula. Has anyone seen this? I just don't understand how it works with the bold, but not the hightlight? Any suggestions or ideas would be greatly appreciated. Thanks.:dunno
I'm trying to set some conditional formatting in an Access report. I have seven columns on the report and the conditional formatting is based on whether or not a field is set to "Yes" or "No". If the field is set to "Yes", then the whole row is supposed to bold and highlight yellow. Is set up the condition as an expression and it works fine for the bold, but not for the highlight. When the field is "Yes" it is bolding the entire row, but it is only highlighting one column in the row. The only difference I see in the columns is that the one that is being highligted is not a formula; all the other columns are based on a formula. Has anyone seen this? I just don't understand how it works with the bold, but not the hightlight? Any suggestions or ideas would be greatly appreciated. Thanks.:dunno