Add zeroes to text box

Good Afternoon,

I have a query whose output is the source of a form (Table view).  Part of this output is latitude and longitude infomration.  I need to display 6 decimal places, but when there are, say 3 decimal places, that is all that is displayed, no "trailing zeroes."

I've tried setting the "decimal places" property to 6 decimal places, but that doesn't correct the problem.

I appreciate your input.


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.

Rey Obrero (Capricorn1)Commented:
try using format([field],"#.000000")
Kent DyerIT Security Analyst SeniorCommented:
I think formatNumber maybe an option too..  It has been a while since I have used Access..

aasikoloAuthor Commented:
That works for latitude, but longitude is negative.  Entering the minus sign has no effect with that format, that is, the minus sign isn't displayed.

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.

Rey Obrero (Capricorn1)Commented:
<That works for latitude, but longitude is negative.  >
you can check if the value is negative or positive, before applying the format

iif([field] < 1,"-" & Format([field],"#.000000"),Format([field],"#.000000"))

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
I may have the wrong end of the stick here but the following expression gives the right output:

    Format(-123.2345, "#.000000")

As far as I can tell, there's no need to conditionally prefix the "-" character.
Rey Obrero (Capricorn1)Commented:
this is ridiculuos!!!
Rey Obrero (Capricorn1)Commented:
explain why you accepted a comment that was a reproduction of a post at http:#a35300049
aasikoloAuthor Commented:
I don't know what is going on.  I accepted your last installment as the answer, awarded points, and I get another comment in the mail.

I reopen EE, thought I was awarding the points to you again, and then I apparently awarded the points to JezWalters.

Please advise on how to correct this situation.

thank you.
Rey Obrero (Capricorn1)Commented:
click on Request Attention above and ask to reopen the thread.
It's normal to accept the first answer that works, so capricorn1's post fits this bill - I was just commenting about a problem with his second post.
aasikoloAuthor Commented:
In case it is not apparent, I requested that a moderator reopen this thread and am waiting for them to do so in order to proceed.

thank you for your patience.
Rey Obrero (Capricorn1)Commented:
aasikoloAuthor Commented:
Let's hope the points get awarded this time
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 Applications

From novice to tech pro — start learning today.