Cont. Form Backcolor by Record

[Guest]

I've got a continous form that I'm hoping to use to moniter a manufacturing
plant's production status. Some of the many fields consist of a Part Number,
Run Qty, and various different processes. My idea is that each applicible
process has a number value indicating what order it needs to be done.
Double-clicking on any of these process feilds will bring up a form asking
the status (Process open or Process Closed). Ideally, if Process-A's status
was set to Open, the backcolor would be yellow. If it were closed, dark grey.

I've figured out how to set the backcolor on the field, no problem there
with a little bit of coding. The problem is that the color is changing for
all of the records in form view, where I need each records colors to be
different.

Does anybody know, if possible, prefereably without much coding, that I can
manipulate the colors to react to a record-by-record basis rather than the
entire form?

As usual, thanks in advance for any advice on the subject.

Jack

 

[missinglinq via AccessMonster.com]

Actually, assuming you're using Access 2000 or later, you don't need any code
at all. For a Continuous Form you need to use Conditional Formatting.

In Design View, click on the "Status" textbox. Goto Format - Conditional
Format.
You'll see a dropdown box marked Condition1 whose value is "Field Value Is."
To the right you'll see a box whose value is "Between." Use the arrow and
change this to "Equal to."
In the next (blank) box to the right type in "closed" (include the quotation
marks)
Now Use the button to the right that has a bucket on it to set the background
color to Gray.

Click on "ADD"

Repeat the above, entering "open" instead of "closed" and set the background
color to Yellow.

Click OK.

This should have you set!

Good Luck!

Linq ;0)>

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[Guest]

Great answer. Thats the easy one that I thought was out there but couldn't
pinpoint. Greatly appreciated

 

[Guest]

The conditional formatting worked very well, with one expection (I should
have thought to explain this in the intial posting). The actual value for
the field that I'm trying to set the condition for is a number that serves as
a counter for what order the process gets done. The value for the StockOpen
field, which tells me if it is open or closed, is in a different toggle
control (stored as 1 or 2 in the table) on a popup form when the Process
field is double clicked. As I need to set the conditions for this field with
the value from another field, and I cannot seem to get the conditional
formatting to take values like that. Is there any chance that I can use the
expression builder ofr something else to work this? Sorry to be bothersome
with questions, I'm not an expert at this. Any help greatly appreciated.

Thanks,
Jack

 

[missinglinq via AccessMonster.com]

Hey, Jack! Came across your last post before I got to this one again. Glad
you got the last bit worked out and got it working!

Linq