|
|
How do I stop Access rounding up the figures I enter in to a form
When I enter £13.75 in to the form, it automatically rounds it up to £14. Or
rounds down when under .5. I have gone in to the design view of the form and
changed the properties so that there are 2 decimal places but this has still
not worked.
Can you please help me?
|
|
0
|
|
|
|
Reply
|
 Utf
|
10/29/2007 3:05:04 PM |
|
The form stores its data in a table.
Open the table in design view.
Select the field where the data is stored.
Change the Data Type from Number to Currency.
The default number is Long Integer
The integer types store whole numbers only.
Your example looks like you want currency, but the Double size can also
store fractional values.
--
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.
"Heidihig" <Heidihig@discussions.microsoft.com> wrote in message
news:7E3A17E1-E64B-40C6-BC1B-151EFCC40DA6@microsoft.com...
> When I enter £13.75 in to the form, it automatically rounds it up to £14.
> Or
> rounds down when under .5. I have gone in to the design view of the form
> and
> changed the properties so that there are 2 decimal places but this has
> still
> not worked.
> Can you please help me?
|
|
|
0
|
|
|
|
Reply
|
Allen
|
10/29/2007 3:15:39 PM
|
|
Hi Allan
Thanks for responding.
Can you clarify the following for me, I am not sure that I understand your
response. I need to go in the table in Design view and then I change the
default number from Long interger to what value? Sorry if I am being thick!!
Any help would be much appreciated !
Thanks
Heidi
|
|
|
0
|
|
|
|
Reply
|
Utf
|
11/3/2007 3:50:00 PM
|
|
Hi Heidi,
Just change the DataType from Number to Currency. Don't wory about the
bottom section.
Heidihig wrote:
>Hi Allan
>Thanks for responding.
>
>Can you clarify the following for me, I am not sure that I understand your
>response. I need to go in the table in Design view and then I change the
>default number from Long interger to what value? Sorry if I am being thick!!
>
>Any help would be much appreciated !
>Thanks
>Heidi
--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200711/1
|
|
|
0
|
|
|
|
Reply
|
ruralguy
|
11/3/2007 4:12:11 PM
|
|
|
3 Replies
2099 Views
(page loaded in 0.092 seconds)
Similiar Articles: How do I stop Access rounding up the figures I enter in to a form ...When I enter £13.75 in to the form, it automatically rounds it up to £14. Or rounds down when under .5. I have gone in to the design view of the form... Numbers are automatically rounding off - microsoft.public.access ...How do I stop Access rounding up the figures I enter in to a form ... Numbers are automatically rounding off - microsoft.public.access ... How do I stop Access rounding up ... How do I stop rounding of my calculation results. - microsoft ...Hello, I am trying to round the results of a calculation without success. ... How do I stop Access rounding up the figures I enter in to a form ... How do I stop ... stop automatic rounding - microsoft.public.accessHow do I stop Access rounding up the figures I enter in to a form ... When I enter £13.75 in to the form, it automatically rounds it up to £14. How to stop Excel from rounding up - microsoft.public.mac.office ...How do I stop Access rounding up the figures I enter in to a form ... How do I stop Access rounding up the figures I enter in to a form ... Change the Data Type from ... Form Rounds up Decimal numbers, WHY? - microsoft.public.access ...How do I stop Access rounding up the figures I enter in to a form ... Form Rounds up ... Numbers are automatically rounding off ... How do I stop Access rounding up the ... Fraction number in Access - microsoft.public.access.forms ...... can use Eval("1/5") to get 0.2 You could do that calculation in a form, allowing the user to enter ... nearest whole number - microsoft.public ... in access, round up ... Round a number/ Access 2007 - microsoft.public.access.formscoding ...How do I stop Access rounding up the figures I enter in to a form ... Round a number/ Access 2007 - microsoft.public.access.formscoding ... How do I stop Access rounding ... How to Round Time in Access? - microsoft.public.accessHow do I stop Access rounding up the figures I enter in to a form ... How to Round Time in Access? - microsoft.public.access How do I stop Access rounding up the figures I ... Rounding up to 2 decimals - microsoft.public.access.queries ...How do I stop Access rounding up the figures I enter in to a form ... How do I stop Access rounding up the figures I enter in to a form ... Rounding off numbers to 2 ... How do I stop Access rounding up the figures I enter in to a form ...When I enter £13.75 in to the form, it automatically rounds it up to £14. Or rounds down when under .5. I have gone in to the design view of the form... Microsoft Access tips: Rounding numbers in AccessHow to round numbers in Microsoft Access: to the nearest number, rounding up, rounding down, to the nearest 5 ... open the Immediate Window (Ctrl+G), and enter: ? Round ... Stop access from rounding up: from, rounding, how, stop, up... stop this..... How do I prevent Access 2000 from rounding 8.75 up ... enter the 8.75 directly into the table, it's fine, but when I put it in the form, it rounds up ... MS ACCESS :: Stop Access From Rounding - BigResource: Webmaster ...What do I need to do to make it stop rounding all of ... I want to round up to whole ... grasp what I need to do. I am using Access 2000. Basically, I have a quote form that ... How to stop rounding numbers down/ up - Access World ForumsMicrosoft Access Discussion > Forms ... Hi Guys, In my form I have a couple of text boxes that you enter numbers to, one is ... Check the field's data type. If you ... 7/20/2012 7:39:00 AM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
39 followers. 