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