ListBox Decimal point?

[GoinDeep]

Does anyone know how to force a listbox to display an additional level of accuaracy in a listbox which displays a value based on an expression in a querry? My querry displays the value to 4 decimal point but my listbox only diplays the value to 2 decimal point.
Thanks!

 

[WayneRyan]

GD,

I think your query has to use the Format function to display the correct
value:

NewField: Format([YourField],"###.000")

Wayne

 

[GoinDeep]

Thanks WayneRyan, works great!

You wouldn' know how to do the same with a table on a chart? I went ahead and changed the format in the supporting query however the values in the chart table do not appear to change.