List/Combo box formating

[Guest]

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!

 

[Douglas J. Steele]

Check what Stephen Lebans has at http://www.lebans.com/justicombo.htm

 

[Guest]

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?