Conditional Formatting in Access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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.
 
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.
 
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.
 
Back
Top