Hi!

What type of the data you have? If numeric values, you will need to convert them to character data type. Following is example of query into array:

SELECT padr(ltrim(str(MyNumericField,14,2)),14) from ...

The benefit is that you also can use any formatting you want, specially when you will use 'transform' function instead of 'str'.

To convert character data back to numeric, use val() function.

>I have a form with a list box that is populated by an array that is made in the init of the form. The list box has 5 columns. My problem is the alignment of the data in each column, they seem to align in the center. I would like them right justified. I cannot find a method to do this. What am I missing? Thanks for the help.