Conditional Formatting

[cevatyildiz]

Dear guys,



I would like to use my excel conditional formatting on a access form and report but do not know how to make it in access. Can you help me in this case?

The sample and the targeted comments are included

Thanks in advance

http://rapidshare.com/files/36746827...formatting.rar

[ConneXionLost]

Hi,

I haven't been able to see your file, however:

In either form design or report design, select the textbox where you want to apply conditional formatting.

Go to the menu item "Format > Conditional Formatting...", or just right-click on the textbox and select "Conditional Formatting...".

From that point the conditional formatting works similar to Excel.

Cheers,

[cevatyildiz]

it's not so simple my friend, my conditional formatting is a bit complex. please see attachment. I really do not know how to write it in Access.

[ConneXionLost]

You're right, they are complex; but perhaps a little more complex than necessary. I modified your formulas a little in Excel, then built the Access versions.

Cheers,

[cevatyildiz]

thats great! actually I want to give orange color if the ETD<Control date and control result is =Y but conditional formatting do not allow us:-( Is there any other way to do it?

Best Regards

[ConneXionLost]

Access 2003 (and Excel 2003) is limited to 3 choices of conditional formatting. This can be overcome using VBA. So far, I've only been able to get it to work in "Single Form" mode.

[cevatyildiz]

Thanks much for your help müsyo

[cevatyildiz]

May we do the same on dahasheet?

[ConneXionLost]

Hi,

If you meant in form "datasheet" view, then that's what I was referring to when I said:

... So far, I've only been able to get it to work in "Single Form" mode.

This may still be possible with VBA, but I've been unable to accomplish it. Perhaps someone more familiar with VBA?

Cheers,