[AccessD] Colorfull listbox or other control

Charlotte Foust cfoust at infostatsystems.com
Wed Feb 19 11:02:59 CST 2003


Not with the built in controls.  There are some custom controls out
there that might allow you to do stuff like this.

Charlotte Foust

-----Original Message-----
From: info [mailto:info at oop.nl] 
Sent: Wednesday, February 19, 2003 1:58 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Colorfull listbox or other control


Dear Group,

I am wondering if it is possible to color one record in a listbox
control to a certain color according to a certain value. For example. In
our app every purchase order has a certain status. Like 10=Made,
20=Ordered, 30=Confirmed, 40=Received, etc. Now they ask if we can make
it possible to give all records in the listbox with status 10 the color
red, with status 20 the color green, etc..

I have tried this but in my case the whole background of the listbox is
getting the color. With about 200 records in the listbox it is becoming
a real nice Disco when opening the form with the listbox:-). I have
tried to find out if I could set the textcolor of a record in a listbox
control but until now I could not find it.

Any Ideas, suggestions?

Gr. marcel

-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Gustav Brock
Sent: woensdag 19 februari 2003 10:30
To: Michael Maddison
Subject: Re: [AccessD] Puzzling error msg? <Invalid precision for
decimal data type.>


Hi Michael

You are into deep sh.t here ...
Val() is for converting a numeric string to a numeric (a Long).

What you probably need is to convert the decimal output of CDbl() to a
string. Str() is for this. And CDbl() is hardly needed for anything as
Fix() returns a numeric.

Thus, I guess you should replace Val(CDbl(Fix(..)/10)) with
Str(Fix(..)/10).

/gustav

> Hey I'm getting desperate :-)
> I might try the Val inside the cDbl...

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list