Colours and Continuous Forms

  • Thread starter Thread starter John Crighton
  • Start date Start date
J

John Crighton

Hi all,

With all of this talk about more than 3 permutations for conditional
formatting not working, I'd like to know if I can in any way achieve the
following (I can't think of a way).

I have a table of vehicles, which are hired out by customers.

The user has specified colours for the customers. (These are picked using
the colo(u)r picker API and I can reference the value and pass it to a
conditional format if I need to.)

I need to show (in a continuous subform view), the vehicles, with several
dates next to them, each colo(u)r coded to the customer hiring it out.

I could do this if conditional formatting accepted more than 3 variations
(as there are likely to be more than 3 customers). I could also do this if I
could put an expression in the 'Back Color' property of a text box to
reference the colour value. However I can do neither of these.

This is incredibly frustrating!

Is there anything anyone can suggest I might do?
 
Thanks for the suggestions -

unfortunately they are of no help at all, although the lebans code was very
interesting!

The first link deals with conditional formatting, which I'm already using,
and as it mentions has a limit of 3/4 colours.

The second link deals with alternate row highlighting - I'm trying to change
the colour of several text boxes in the same record. I suppose I could use
this approach and generate a complex picture for the form background which
replicates the colours used in the timetable for the different customers,
but I think that might be a little too complex!

Any others? If someone would tell me it can't be done I'd be just as
satisfied.

Thanks.

John C

Go to: http://www.rogersaccesslibrary.com
Click to expand...
and click on ChangingColorFields.
Click to expand...
He has created a sample Access Database that
Click to expand...
shows you several different way to conditionally format
Click to expand...
 
John said:
Thanks for the suggestions -

unfortunately they are of no help at all, although the lebans code was very
interesting!

The first link deals with conditional formatting, which I'm already using,
and as it mentions has a limit of 3/4 colours.

The second link deals with alternate row highlighting - I'm trying to change
the colour of several text boxes in the same record. I suppose I could use
this approach and generate a complex picture for the form background which
replicates the colours used in the timetable for the different customers,
but I think that might be a little too complex!

Any others? If someone would tell me it can't be done I'd be just as
satisfied.
Click to expand...


Stephen had a suggestion in your other thread.
 
Back
Top