Highlight records on continuous forms (1 Viewer)

Brian Martin

Registered User.
Local time
Today, 10:24
Joined
Jul 24, 2002
Messages
68
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

Now Known as ___
Local time
Today, 10:24
Joined
Sep 11, 2002
Messages
723
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

Registered User.
Local time
Today, 10:24
Joined
Jul 24, 2002
Messages
68
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

Now Known as ___
Local time
Today, 10:24
Joined
Sep 11, 2002
Messages
723
Expression is [checkbox]=True

Then select the colours etc you'd like

IMO
 

IMO

Now Known as ___
Local time
Today, 10:24
Joined
Sep 11, 2002
Messages
723
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
 

IMO

Now Known as ___
Local time
Today, 10:24
Joined
Sep 11, 2002
Messages
723
You're welcome

IMO
 

Users who are viewing this thread

Top Bottom