[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 931
  • Last Modified:

Continuous form, different color background depending on record status

I am showing the a continuous form containing both active and inactive records.  This is based on the contents of field 'Active_YN'.

I wanted to put a yellow background on inactive records and white on active records so I tried this in the Current event:

If active_yn=-1 then
        me.detail.background = vbyellow
else
       me.detail.nackground= vbwhite
endif

This doesn't work as I had hoped.  When an active record is current the entire background of the form is white, when an inactive record is current, the entire background of the form is yellow.

I want the user to look at a continuous screen with multiple records showing.  The inactive ones would have a yellow background and the active ones would have a white background.

Is this possible ?
0
mlcktmguy
Asked:
mlcktmguy
  • 2
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<Is this possible ? >>

 Yup.  What you need to use is condition formatting.  

A continuous form is an odd duck; most of it is not really there<g>, but rather "painted" on the screen.

 As a result, one of things that's tough is formatting.   But with conditional formatting it's easy.

  Just specify the rule, then the condition you want (background a specific color).

Jim.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
0
 
mlcktmguyAuthor Commented:
Thanks
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now