Highlight records on continuous forms

[Brian Martin]

I have a continuous form. If a records urgent field is ticked true then I want that record to be displayed in red text. I want to keep the continuous form. How can I do this??

 

[IMO]

I assume you're using A2K. In Design mode select the field you'd like formatted and go to the menu - Format >> Conditional Formatting.

IMO

 

[Brian Martin]

I'm trying to do something with conditional formatting. Im a bit puzzled how I can format the Part Number text box based on the value of the Urgent check box???

 

[IMO]

Expression is [checkbox]=True

Then select the colours etc you'd like

IMO

 

[IMO]

Sorry, I didn't explain that very well

Select the field you'd like formatted, go to conditional formatting and change the Condition1 dropdown to 'Expression is' then type in [NameOfYourCheckBox]=True

IMO

 

[Brian Martin]

Thanks

Easy once u know how!! Thanks IMO

 

[IMO]

You're welcome

IMO