Conditional Formatting in Access Datasheets

[Guest]

Hi all,

Got a query with regards to conditional formatting in datasheets.

I know that it's possible to do Conditional Formatting at the Form/Design
view, but is it possible to do this in the datasheets itself (either through
VBA code, or through Access functions). I've did some Googling, but realised
that this is only available at the Forms level.

Am using Access 2002 SP3 though (but do let me know if newer Access versions
are able to do this).

It would be great if anyone has any solutions/workarounds for this. Thanks
all!

 

[Guest]

Hi

Condidtional formating works fine on datasheets.
Open the form in design view ("not" datasheet)
Set the contional formats for each control as you want
View the datasheet.

HTH