Bitmap OLE objects/coloured text in continuous datasheet forms

[Atomic Shrimp]

I've got a datasheet subform which contains a list of invoices to be extracted for transmission by EDI... anyway each item in the list can be one of: 'New', 'Seen Before' 'Failed', 'Not Available' etc.

So in the underlying table I have a column 'status' that contains a number which relates to a particular status.

OK so far, but I want 'New' to appear in green, 'Failed' in red and so on - I had started to do this by making the status flag either +1, 0 or -1 and using the format property, but there are a couple of problems with this:
-'Status' has more than the three (or four with null, which I can't really use) possible states which the format property will allow me to display.
-The [Green] colour that the Format property gives is too faint to be any use, I want something a bit darker.

So I thought I would create my own little bitmaps (made of coloured text in Paintbrush) in a related table in all sorts of colours and use them, but they don't display as bitmaps in the continuous form view

So, what do I do? any ideas? - I really would like to use a different colour for each possible state.

Hope the above makes some sort of sense.

Mike

 

[Richie]

I found a site which showed a method of displaying a different coloured backround text based on different check boxes being selected on a cont. form, I adapted it slightly to change based on the number displayed in a hidden text box, unfortunately I've forgotten the original site but can send a copy if your interested.

 

[Carol]

If you are using Access 2000, you can use the Conditional Formatting for a field that will produce what you want. Highlight the field that you wish to set to different colours, it can be a maximum of 3, plus your default. Select Format on your main menu bar and then select Conditional Formatting.

Good Luck

 

[Atomic Shrimp]

Thanks People!, I am going to have to invest in A2K sooner or later, I can tell.

Mike

 

[Atomic Shrimp]

Richie, I'd love a copy of your demo. I tried to email you but got back an error message.

Mike

 

[Richie]

Try richiet@lineone.net

 

[Atomic Shrimp]

Thanks Richie, hey, who needs conditional formatting?!

I've also adapted this technique to colour a whole row red in the continuous form if the transaction value is less than zero, and it works wonderfully.

Mike

 

[hangglide]

Thanks Richie, hey, who needs conditional formatting?!

I've also adapted this technique to colour a whole row red in the continuous form if the transaction value is less than zero, and it works wonderfully.

Mike

Could you please post this on the board?

Leo

 

[Atomic Shrimp]

You can download it here.

HTH

 

[Rich]

I lost the original some time ago, here's another use of much the same method
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=60191
Richie