List Box Question

[ddrew]

Is it possible to produce something like the attached file. Thanks!

 

[KenHigg]

I think your best bet is to try and do it with a subform...

 

[ddrew]

OK, I know how to do a subform and how to put the words in but I have no idea how I would go about putting in the colours. Any help appreciated, thanks.

 

[KenHigg]

Hum... I've never done anything like that either...

Will the colors/options be fixed or will you need to be able to add/edit them?

 

[ddrew]

They will be fixed, although thinking about it I may give each colour a number as I want to use the complete colour pallete that access can use i.e 48 basic colours. Using numbers because trying to describe the colour would be a nightmare! i.e Blue, Light Blue, Slightly Lighter Blue , etc, etc be a bit daft I think!

 

[supercharge]

I'm brainstorming this, how about using a table with two columns and base your combobox on it. One column contains pictures of different colors and the other column contains the descriptions or numbers or whatever you want.

Again, just brainstorming. Haven't tried it. I will try later on.

 

[ddrew]

Ha, great minds think alike I am just trying that. Problem is when I create the combobox it will only allow me to put in the text box, the picture I inserted as an OLE object wasnt allowed.

 

[supercharge]

Good! now if you can figure out how to embed pictures in a table then there you go.