Too many decimals displayed

[dt2demar]

I'm displaying data using a listbox on a form. However it's displaying 12 digits of decimals which is unecessary.

I notice that the number of decimal places can be specified when using a combobox properties. How can I do the same for a listbox?

thanks,

 

[MichaelRed]

One way is t use the format function. Check HELP for the arguments.


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over

 

[dt2demar]

I did a search for 'format function' and I found the following (see below). I'm now sure how I can use this though? I tried putting it into the query field that calculates the data, but it gives me an error. Any help would be appreciated.

FIXED
Rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text.

Syntax

FIXED(number,decimals,no_commas)

Number is the number you want to round and convert to text.

Decimals is the number of digits to the right of the decimal point.

No_commas is a logical value that, if TRUE, prevents FIXED from including commas in the returned text. If no_commas is FALSE or omitted, then the returned text includes commas as usual.

Numbers can never have more than 15 significant digits, but decimals can be as large as 127.


If decimals is negative, number is rounded to the left of the decimal point.


If you omit decimals, it is assumed to be 2.

 

[JoeMiller]

The usage of the format command is like so:

format([DataToFormat],"How you want it formatted&quot

So if you wanted to do two decimals (there are other ways to format this, this is only one!!)

format([DataToFormat],"0.00&quot

Hope that helps!
Joe Miller
joe.miller@flotech.net

 

[dt2demar]

Yes. That solves my problem. Thank-you very much.

This website is awesome!!