List Box Data Output (1 Viewer)

[ray147]

I have a list box control on a form which is being populated by a query. It is showing bookings that are placed on three shifts (AM, PM, Night shifts)...the list box is working fine...

- what i'd like is that the output in the listbox is seperated by shift (maybe having a blank line when shift changes, or different text color for different shift, or different background colour for different shift? )


i'm not quite sure if this can be done...or maybe there's another way out ? any ideas?

thanks!

 

[ray147]

no ideas?!

 

[Dembrey]

I'm pretty sure what you are asking for can't be done with the standard Listbox object. The only way I can think how to do something similar is to use a continuous subform, I believe Access2003 can do conditional formatting.

HTH.

 

[ray147]

i'm using Access 2000

 

[Dembrey]

My Company 'leapt' from A97 to 2003 so I have no experience of A2000.
If conditional formatting isn't built-in to A2000 it can still be approximated using some slight of hand. Search the forums for some examples there are many posts on the subject. Also some info is given here: http://www.mvps.org/access/forms/frm0024.htm