Formatting data in list box

S

stevens

Is there any way to format data in one of the columns of a list box besides
formating it before it gets to the box? I have a column that has floating
point numbers and would sure like to limit them to 2 decimal places. I know
one of you MVPs out there has an answer to this one, even if it is no.
thanks
Steve
 
D

Douglas J. Steele

AFAIK, your only choice is to use a format statement in the underlying
query.
 
T

Tom Wickerath

Hi Steve,

Try using the Format function in a SQL statement that serves as the row
source for your list box. Something like this:

SELECT Format([MyNum],"##,##0.00") AS MyNumber FROM Table1;

or

SELECT Format([MyNum],"Standard") AS MyNumber FROM Table1;

where "MyNum" is the name of your field and "Table1" is the name of your
table.


Tom
_______________________________________

:

Is there any way to format data in one of the columns of a list box besides
formating it before it gets to the box? I have a column that has floating
point numbers and would sure like to limit them to 2 decimal places. I know
one of you MVPs out there has an answer to this one, even if it is no.
thanks
Steve
 
Top