Tags: access, created, database, decimal, form, input, ive, maintain, microsoft, mysql, number, oracle, places, roundsoff, sql, table, values

Form won't show decimal input

On Database » Microsoft Access

2,739 words with 3 Comments; publish: Tue, 03 Jun 2008 22:59:00 GMT; (25046.88, « »)

I've created an input form that places values into a table. My form rounds

off any decimal input to a whole number. How do I maintain the decimal input?

I've done the following:

My table field is formatted to General number with a decimal place of 2

My form field property matches my table field.

Thank in advance for your help. I know this is a simple issue, but I must be

brain dead!

All Comments

Leave a comment...

  • 3 Comments
    • dab1477 wrote:

      > I've created an input form that places values into a table. My form

      > rounds off any decimal input to a whole number. How do I maintain the

      > decimal input?

      > I've done the following:

      > My table field is formatted to General number with a decimal place of

      > 2

      > My form field property matches my table field.

      > Thank in advance for your help. I know this is a simple issue, but I

      > must be brain dead!

      What is the Field Size setting of your field? I'm guessing Integer or Long

      Integer neither of which support decimals.

      I don't check the Email account attached

      to this message. Send instead to...

      RBrandt at Hunter dot com

      #1; Tue, 03 Jun 2008 23:00:00 GMT
    • Dab,

      You probably have designated this field's DataType as a Byte, Integer, or

      Long Integer in your table design. Those are "whole number" Types, and

      don't allow for decimals... regardless of what your Format is.

      Try Single or Double...

      hth

      Al Camp

      "dab1477" <dab1477.ms-access.itags.org.discussions.microsoft.com> wrote in message

      news:601BA23C-E003-42D4-8D60-7517971B9797.ms-access.itags.org.microsoft.com...

      > I've created an input form that places values into a table. My form rounds

      > off any decimal input to a whole number. How do I maintain the decimal

      > input?

      > I've done the following:

      > My table field is formatted to General number with a decimal place of 2

      > My form field property matches my table field.

      > Thank in advance for your help. I know this is a simple issue, but I must

      > be

      > brain dead!

      >

      #2; Tue, 03 Jun 2008 23:01:00 GMT
    • That was it! Like I said, I went brain dead. Thanks for the jolt back to

      reality.

      "AlCamp" wrote:

      > Dab,

      > You probably have designated this field's DataType as a Byte, Integer, or

      > Long Integer in your table design. Those are "whole number" Types, and

      > don't allow for decimals... regardless of what your Format is.

      > Try Single or Double...

      > hth

      > Al Camp

      > "dab1477" <dab1477.ms-access.itags.org.discussions.microsoft.com> wrote in message

      > news:601BA23C-E003-42D4-8D60-7517971B9797.ms-access.itags.org.microsoft.com...

      >

      >

      #3; Tue, 03 Jun 2008 23:02:00 GMT