I have the following code in the 'InterActiveChange' method of a listbox (.lstDim1):

.lstDim2.RowSource = 'Select DISTINCT IIF(dim2-INT(dim2)>0,'+;
   'ALLTRIM(STR(dim2,5,1)),ALLTRIM(STR(dim2))) AS dim2 FROM surface '+;
   'INTO CURSOR curDim2 WHERE ALLTRIM(.lstDesc.Value)==ALLTRIM(desc) '+;
   'AND .lstDim1.Value==fractionconv(dim1) ORDER BY dim2'

This fills listbox 'lstDim2' with the correct data, but when I go to select a value the only values that will show up in the listbox are the ones that do not contain a decimal (i.e. ALLTRIM(str(dim2)) from above).

Any suggestions would be greatly appreciated!

Thanks in advance,
Russell