Adjusting decimal places in unbound list box

I have a unbound list box on a form in Access database.  I want some values to be 3 decimal places and some to be 4, but all are rounding to two.  Some are pulling values from table and some from queries.  How can I control the # of decimal places shown on form?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
You did not post many details on the listbox, other than to say it is unbound...

I don't think that you can specify that some values in a column to be 3 decimal places and others to be 4.

Or ...are you saying this this is needed for different "Columns".

If so, then set the number of decimal places in the "table" that provides these values.

Dale FyeOwner, Developing Solutions LLCCommented:
You must define that number in the query that is the rowsource for your listbox

Start out by using the Round([fieldname], decimal places ) function to get the right number of decimals.

Keep in mind, that all entries in a listbox are treated as text and will be left aligned.  Another option would be to create a continuous form, which would give you the ability to align these numeric values to the right of a textbox.
Jeffrey CoachmanMIS LiasonCommented:
...For example, in the table, set the field property: Format to "Fixed"
Then set the decimal places property as needed. (2 or 3 ,...or whatever...)
Then when you load these values into the listbox, they will have the desired decimal places.


10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

Dale FyeOwner, Developing Solutions LLCCommented:
The reason I recommended the Round( ) function was that the OP indicated some needed 3 decimals, some need 4.  Unfortunately, Access doesn't have a decimal align feature like Word and Powerpoint do.  Now, that would be a useful addition.
Caidley2kAuthor Commented:
I was able to resolve this in the table I had created.  The Data Type is currency, but changed the format to general number and set the decimal places at what I wanted it to be.  This way allows my unbound text box to show the decimal placed I want.  
Thanks to all for your suggestions.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jeffrey CoachmanMIS LiasonCommented:
OK by me.

Just a note.
With a currency datatype you can set the number of decimals places as well (so there may be no need to change the datatype.

If you change the datatype from Currency you loose the default currency format (Dollar sign, thousandth separator), and you may end up having to "format" the final result as currency anyway...

Caidley2kAuthor Commented:
My own comment was the easiest way for me to reach a conclusion.  Not saying any of the others wouldn't work, but based on my skill-set this was best approach for me.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.