Solved

Continuous form, different color background depending on record status

Posted on 2014-03-09
3
838 Views
Last Modified: 2014-03-09
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
Comment
Question by:mlcktmguy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 250 total points
ID: 39916190
<<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
 
LVL 57
ID: 39916192
0
 
LVL 1

Author Closing Comment

by:mlcktmguy
ID: 39916219
Thanks
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question