Hi,
I am currently working on a database and have some little issues with list boxes on forms. Some formatting issues which seem simple but can't figure out ...
I'm attaching a sample DB with one table and one form having a list box. 3 things which i'd like to have with my list box :
1. is it possible to right-align the values in the last 3 columns of the listbox?
2. is it possible to have the rate displayed in 4 decimal places rather than 2? I have formatted the query to output the results in 4 decimal places but the listbox still outputs only 2 decimal places.
3. is it possible to sort the data in the listbox by clicking on the column headers? or this is only possible by placing command buttons and filtering the SQL query according to requirements?
Thanks in advance for any help
I am currently working on a database and have some little issues with list boxes on forms. Some formatting issues which seem simple but can't figure out ...
I'm attaching a sample DB with one table and one form having a list box. 3 things which i'd like to have with my list box :
1. is it possible to right-align the values in the last 3 columns of the listbox?
2. is it possible to have the rate displayed in 4 decimal places rather than 2? I have formatted the query to output the results in 4 decimal places but the listbox still outputs only 2 decimal places.
3. is it possible to sort the data in the listbox by clicking on the column headers? or this is only possible by placing command buttons and filtering the SQL query according to requirements?
Thanks in advance for any help