By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,283 Members | 1,721 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,283 IT Pros & Developers. It's quick & easy.

Showing currency decimal values in formns

P: n/a
Hi All,

I designed an input query as the basis of a form. Some fields (like for pennies) are numbers that I formatted as currency and specified as 2 decimal places. However, it appears to round down anything under 50, which then displays as $0.00 and appears to round up anything over 51, which then displays as $1.00

How can I get these to show up "Properly" in the form?

Thanks very much,
Chuck
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Open the table in design view.
Select the field that gives you this problem.
Change the Field Type to Currency.

The integer type numbers store whole numbers only.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Chuck Insight" <j.*******@insightbb.com> wrote in message
news:ucnwe.113159$xm3.2863@attbi_s21...

I designed an input query as the basis of a form. Some fields (like for
pennies) are numbers that I formatted as currency and specified as 2 decimal
places. However, it appears to round down anything under 50, which then
displays as $0.00 and appears to round up anything over 51, which then
displays as $1.00

How can I get these to show up "Properly" in the form?

Thanks very much,
Chuck
Nov 13 '05 #2

P: n/a
It Worked - Yipee

Thanks very much,
Chuck

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.