Dymamic Form Formatting

[Guest]

Thanks in advance...

I have a continuos form setup up that shows records monitering the status of
production parts moving through a manufacturing plant. The left side
contains part and order information and the right side holds workstation
information. The workstation fields hold a number value that is a sequence
number for what order they need to be run. Each workstation field has a
dblclk activated subform that handles details such as how many operations
need to be done for this particular station.

So, I've got 16 different workstation fields, each of which may have 5
different operations to it. Based on what the input is for the workstations
and operations, I have a formula worked out that will total a value which is
equal to various different colors (dark yellow to bright yellow for pending
operations depending on the number of operations, same with green for
currently processing operations).

What I need to do is format each workstation field backcolor on the main
form (the one holding the sequence number) based on which value my formula
returns.

I've tried this a number of ways. First I set the format on the form
control to equal whatever value I had come up with for it. Which worked,
except it did it for every record on the form where I needed it to work only
on the current record. Then I was advised to use conditional formatting,
which worked as well. It put the formatting on a record-by-record basis, but
I don't have enough options with conditional formatting to pick any of the 14
colors that I'm using.

I'm not sure where to go from here. I don't think that this can be done via
conditional formatting because it only allows 3 conditions, though I am not
quite sure how to code the form so that it acts on a single record level.
I'm no code expert, but I should be able to handle getting the value I need
and setting the format to what I want, it's getting it to each record
individually that I'm stuck on.

As mentioned, and advice would be greatly appreciated, and thanks to those
who've gotten me this far.

Jack

 

[Albert D. Kallal]

While conditional formatting can be used to have MANY more then 3
conditions. (since you an use a function as an expression) to return values.

However, you still limited to 3 result colors. If you have several text
boxes, then they can of course each have their own colors...but, for one
column?

You have to do one of two things:

1) Simply dump your idea, save the expensive developer costs, and give that
money to feed to poor.

2) If you design specs really do requite the colors, then just use a 3rd
party tool.

tlist7 is quite nice..and it works well with access....

You an find the control here:

http://www.bennet-tec.com/btproducts/tlist/tlist.htm

and, some screen shots here:

http://www.bennet-tec.com/btproducts/tlist/TListScreenShots.htm

 

[Marshall Barton]

I have a continuos form setup up that shows records monitering the status of
production parts moving through a manufacturing plant. The left side
contains part and order information and the right side holds workstation
information. The workstation fields hold a number value that is a sequence
number for what order they need to be run. Each workstation field has a
dblclk activated subform that handles details such as how many operations
need to be done for this particular station.

So, I've got 16 different workstation fields, each of which may have 5
different operations to it. Based on what the input is for the workstations
and operations, I have a formula worked out that will total a value which is
equal to various different colors (dark yellow to bright yellow for pending
operations depending on the number of operations, same with green for
currently processing operations).

What I need to do is format each workstation field backcolor on the main
form (the one holding the sequence number) based on which value my formula
returns.

I've tried this a number of ways. First I set the format on the form
control to equal whatever value I had come up with for it. Which worked,
except it did it for every record on the form where I needed it to work only
on the current record. Then I was advised to use conditional formatting,
which worked as well. It put the formatting on a record-by-record basis, but
I don't have enough options with conditional formatting to pick any of the 14
colors that I'm using.

I'm not sure where to go from here. I don't think that this can be done via
conditional formatting because it only allows 3 conditions, though I am not
quite sure how to code the form so that it acts on a single record level.
I'm no code expert, but I should be able to handle getting the value I need
and setting the format to what I want, it's getting it to each record
individually that I'm stuck on.

You can use CF (with some performance penalty). Here's a
previous post on this topic:

http://groups.google.com/group/micr...138fdb765ae?lnk=st&q=&rnum=2#44896138fdb765ae