Round a number in a list box

[Seeff]

Hi...I have a listbox that lists a field containing numbers. The numbers have many decimal places and I would like to show them in the listbox with only one decimal place. For eg. instead of 1.2345 I would like to see 1.2 in the list box.

Any ideas and thanks for your replies.

 

[danvlas]

If you use Access 2000/XP, you have the Round function.
For Access 97, Paste this into a module:

Function DnRound(Expression As Double, Optional decimals = 2) As Double
DnRound = Int(Expression * 10 ^ decimals + 0.5) / (10 ^ decimals)
End Function

Then, change the row source of the listbox: instead of
Select FieldName From TableName
make it:
Select Round(FieldName, 1) As RoundedValue from tableName)
Of course, for Access 97 Round should be replaced by DnRound.

Good luck


Daniel Vlas
Systems Consultant

 

[Seeff]

Works fine and a thank you very much!