Format a Column in a Listbox

[Serrin]

My Listbox has several columns. One column is a calculated value (calculated using an SQL-Function). The columns from my table used to calculate my special column all have 1 decimal. But my calculated column has from 0 to x decimals!!!

- Is there a way to format my Listbox-column?

- Or is there a way to write an intelligent Access-SQL statement that sets the decimals of my calculated column to 1?

thanks,
Serrin
serin@gmx.net

 

[JoeMiller]

Access will sometimes automatically round numbers for display when then the field, control, listbox etc.. is not wide enough. Try making the column with your number wider to see if more numbers appear.

You could also use the format() function in your query to specify how many decimals the data should have.

HTH Joe Miller
joe.miller@flotech.net