List/Combo box formating

K

kabaka

Hi

I have a combo box based on a sql statement returning more that one column.

One of the columns is numeric (###,###.##). Is there a way to right align
this column? Currently every column is left aligned which is fine for text
but makes for a rather messy and difficult to read number column.

Thank you for the help!
 
K

kabaka

Thanks very much; it works perfectly - almost.

So long as I enter use the function in my rowsource property (that is, from
the form design I enter it in) it works. However, if I change my rowsource
through code (which I do as sort of a customized filter) all I get is blank
values for the field that I call the function from.

Any suggestions?
 
Top