Unbound listbox set fontcolor for each value

  • Thread starter Thread starter Harmannus
  • Start date Start date
H

Harmannus

Hallo,

Is it possible to set the fontcolor for each value in a unbound listbox?

So i have a listbox based on a query (see below). In a subtable i have
colorcodes corresponding with a group in tblSales. Based on the colorcode of
the GroupID in tblSales i would like the field Sales to be shown in the
corresponding ColorCode e.g. Red.

Something like "For each value Me.Sales.FontColor=ColorCode.value". Can this
be done?

tblSales
SalesID
SalesDescription
GroupID

tblGroup
GroupID
GroupDescription
ColorID

tblColor
ColorID
ColorCode

qselSales: SalesID, Sales: SalesDescription &", "&GroupDescription

Thanx for any tips!

Regards,
Harmannus
 
Harmannus said:
Is it possible to set the fontcolor for each value in a unbound listbox?

So i have a listbox based on a query (see below). In a subtable i have
colorcodes corresponding with a group in tblSales. Based on the colorcode of
the GroupID in tblSales i would like the field Sales to be shown in the
corresponding ColorCode e.g. Red.

Something like "For each value Me.Sales.FontColor=ColorCode.value". Can this
be done?

tblSales
SalesID
SalesDescription
GroupID

tblGroup
GroupID
GroupDescription
ColorID

tblColor
ColorID
ColorCode

qselSales: SalesID, Sales: SalesDescription &", "&GroupDescription
Click to expand...


No, a list box has no properties for this kind of thing.

I'm not sure, but you may be able to achieve a similar
effect using a continuous subform along with Stephen Lebans'
http://www.lebans.com/formatbycriteria.htm
 
Back
Top