Tags: access, allive, anddecimal, database, entering, fixed, form, ive, microsoft, mysql, numbers, numeric, oracle, places, prevent, properties, rounding, setting, sql, table

How to Prevent Rounding of Numbers

On Database » Microsoft Access

2,855 words with 3 Comments; publish: Wed, 04 Jun 2008 01:09:00 GMT; (25093.75, « »)

Hi all

I've having problem entering numeric data.

I've tried setting the table and form properties to Fixed/General and

Decimal Places to 2 but still the access form keeps rounding the

numbers and same rounded figures get entered in the table.

How to resolve this issue?

There is another field(bounded text box) which displays calculated

value ,and its showing the decimal values properly.Its properties are

set to Fixed and 2 Decimals.

Pls Help

THanks

Mike

All Comments

Leave a comment...

  • 3 Comments
    • What type of field is it? Look at the table design and check the "Field

      Size". Is it set to integer, or something that does not support decimal

      places?

      Rick b

      "mike" <kmchunk.ms-access.todaysummary.com.yahoo.com> wrote in message

      news:1112114532.759415.233570.ms-access.todaysummary.com.z14g2000cwz.googlegr oups.com...

      > Hi all

      > I've having problem entering numeric data.

      > I've tried setting the table and form properties to Fixed/General and

      > Decimal Places to 2 but still the access form keeps rounding the

      > numbers and same rounded figures get entered in the table.

      > How to resolve this issue?

      > There is another field(bounded text box) which displays calculated

      > value ,and its showing the decimal values properly.Its properties are

      > set to Fixed and 2 Decimals.

      > Pls Help

      > THanks

      > Mike

      >

      #1; Wed, 04 Jun 2008 01:10:00 GMT
    • Rick B wrote:

      > What type of field is it? Look at the table design and check the

      "Field

      > Size". Is it set to integer, or something that does not support

      decimal[vbcol=seagreen]

      > places?

      > Rick b

      >

      > "mike" <kmchunk.ms-access.todaysummary.com.yahoo.com> wrote in message

      > news:1112114532.759415.233570.ms-access.todaysummary.com.z14g2000cwz.googlegr oups.com...

      and[vbcol=seagreen]

      are[vbcol=seagreen]

      The Field looks up the value in a textbox ( ie textbox in the form)

      Data type : Number

      Field Size : Long Integer

      Format :General Number

      Decimal Places: 2

      It just cant understand whats the problem

      #2; Wed, 04 Jun 2008 01:11:00 GMT
    • The problem is that the Long Integer data type is by its very nature capable

      of storing only whole numbers. If you want to store decimal values you need

      to pick a number type of anything that doesn't contain the word "Integer" in

      it.

      "mike" <kmchunk.ms-access.todaysummary.com.yahoo.com> wrote in message

      news:1112119250.722566.251390.ms-access.todaysummary.com.g14g2000cwa.googlegr oups.com...

      > Rick B wrote:

      > "Field

      > decimal

      > and

      > are

      >

      > The Field looks up the value in a textbox ( ie textbox in the form)

      > Data type : Number

      > Field Size : Long Integer

      > Format :General Number

      > Decimal Places: 2

      > It just cant understand whats the problem

      >

      #3; Wed, 04 Jun 2008 01:12:00 GMT