How do you create the array? You can simply add backslash in your select statement.
E.g.
select iif(lActive,MACHINE+" ","\" + machine) as Machine, ... ;
from myTable into array thisform.myComboArray
>I am using an array, which I created from a SQL statement from a table called MACHINES. If I am not using AddItem, then how do I accomplish this? Is it more difficult then the way in which I puit together my drop-down list from an array?
>
>I added a few more fields to the table to keep track of who is making the changes and whether or not the record is active, or that is if the WIRE DRAWING machine is still utilized:
>
>MACHINE
>LACTIVE
>LASTUPDATE
>USERNAME
>
>>>Is it possible to have different colors for items in a drop-down list?
>>>
>>>My idea is that for the items which are no longer available that I'd color them forecolor=RED and anythign else available as BLUE.
>
>>You can disable certain items by adding '\' (mild) or '\]' (hard). For example, Combobox.Additem('\]noavail') will show 'noavail' as disabled and user won't be able to access it.
If it's not broken, fix it until it is.
My Blog