Conditional Formatting in Access 2003

[Guest]

Is Conditional formatting available for a control in datasheet view in access
2003? The Help seems to suggest it is, but I suspect it is referring to the
access 2007 feature as I can't find 'Conditional formatting' on either my
format menu nor format tab (ie on the control properties) as the Help
instructs. Thanks - Jenny

 

[fredg]

Is Conditional formatting available for a control in datasheet view in access
2003? The Help seems to suggest it is, but I suspect it is referring to the
access 2007 feature as I can't find 'Conditional formatting' on either my
format menu nor format tab (ie on the control properties) as the Help
instructs. Thanks - Jenny

On a form correct?
Open your form in form design view.
Select the control you wish to conditionally format.
Then click on Format + Conditional Formatting.
On the Condition1 drop-down select the appropriate value:
Field Value Is, Expression Is, or Field Has Focus.
Then complete the next dialog box.
Select the control colors, etc.

Click OK to save the changes.

 

[Guest]

Thanks - half the problem with this stuff is knowing where to look - I had
tried both the format menu option and format tab on the properties box but
'conditional formatting' does not appear in either. I tried right mouse on
the control and hey presto - there it was - pity the Help does not explain
things a bit more comprehensively.

 

[Guest]

One more thing fredg - is that code (the conditional formatting code)
accessible anywher?! I want to make the parameters user defined but my
product is made into an mde so the users can not access the forms in design
mode, so I would need to set the formatting using VBA. Thanks.