‘Fraid to bring up the same old question on formatting each row on a
continuous form according to information it holds. Conditional formatting is
not an option I have a table of Events
EventID
EventDate
EventTypeID

And a table of EventTypes
EventTypeID
EventTypeColour ‘Long Colour code for this type of event
EventTypePic ‘ OLE object

I want a continuous form showing the event, and coloured according to the
colour defined by EventTypeColour. I know Stephen Lebans has cracked this,
but it is pretty hairy. There is a very simple method at
http://www.access-programmers.co.uk/...d.php?t=154634 using a
coloured bitmap OLE object as a transparent control covering each record
(EventTypePic, hence the 2 alternative sorts of colour information in the
EventsTypes table) Has anyone a neat solution to the problem (Access 2010) or
is there a way of using the standard windows colour picker to create the OLE
bitmap?

Thanks

Phil

On 31/10/2011 16:07:49, "christianlott1 (AT) yahoo (DOT) com" wrote:
Thanks Christian

Don't thin that helps, but I will look into it forther.
I am trying to produce a continous form with the backgrond colour of a text
box depending on a value (currently using the numeric value of the colour e.g
255 - Red) I need about a dozen text boxes all in different colours. I get
the impression that even using VBA you are limited to 3 3 colours / textbox +
the default colour

Thanks

Phil

I think the only way is like the demo shows - unless you want to use
Access for DOS 1.0 or an embedded web page.

I'd just use the conditional formatting on the Event Type combo or
text box to set the background color of that single control, not the
whole row.