Decimal Problem in field and textbox

[ApexData@gmail.com]

I have a field set to 1 decimal place in the table definition.
I have a textbox bound to the field also set to 1 decimal place.

Why can I enter the number 1.57 in the textbox, and this becomes
stored in the table as well ? Do I have to use a input mask to stop
this ?

Thanks

[bhicks11 via AccessMonster.com]

Re: Decimal Problem in field and textbox

Make sure your first field type is Number - anything other than Integer or
Long Integer which will only show whole number.

Bonnie

http://www.dataplus-svc.com

ApexData@gmail. com wrote:

>I have a field set to 1 decimal place in the table definition.
>I have a textbox bound to the field also set to 1 decimal place.
>
>Why can I enter the number 1.57 in the textbox, and this becomes
>stored in the table as well ? Do I have to use a input mask to stop
>this ?
>
>Thanks

--
Message posted via http://www.accessmonster.com

[bhicks11 via AccessMonster.com]

Re: Decimal Problem in field and textbox

Make sure your first field type is Number - anything other than Integer or
Long Integer which will only show whole number.

Bonnie

http://www.dataplus-svc.com

ApexData@gmail. com wrote:

>I have a field set to 1 decimal place in the table definition.
>I have a textbox bound to the field also set to 1 decimal place.
>
>Why can I enter the number 1.57 in the textbox, and this becomes
>stored in the table as well ? Do I have to use a input mask to stop
>this ?
>
>Thanks

--
Message posted via AccessMonster.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200806/1

[ApexData@gmail.com]

Re: Decimal Problem in field and textbox




The table field is a number / decimal with decimal set to 1 place.
If I enter 1.57 in the table directly or in my forms textbox, it
changes to 1 with
no decimal places ???





On Jun 22, 2:10 pm, "bhicks11 via AccessMonster.c om" <u44327@uwe>
wrote:

Make sure your first field type is Number - anything other than Integer or
Long Integer which will only show whole number.  
>
Bonniehttp://www.dataplus-svc.com
>
ApexD...@gmail. com wrote:

I have a field set to 1 decimal place in the table definition.
I have a textbox bound to the field also set to 1 decimal place.

>

Why can I enter the number  1.57 in the textbox, and this becomes
stored in the table as well ?  Do I have to use a input mask to stop
this ?

>

Thanks

>
--
Message posted via AccessMonster.c omhttp://www.accessmonst er.com/Uwe/Forums.aspx/databases-ms-access/2008...

[bhicks11 via AccessMonster.com]

Re: Decimal Problem in field and textbox

In the table design, look down under general while you are on the number
field. What value is in Field Size?

Bonnie

http://www.dataplus-svc.com

ApexData@gmail. com wrote:

>The table field is a number / decimal with decimal set to 1 place.
>If I enter 1.57 in the table directly or in my forms textbox, it
>changes to 1 with
>no decimal places ???
>
>On Jun 22, 2:10 pm, "bhicks11 via AccessMonster.c om" <u44327@uwe>
>wrote:

>Make sure your first field type is Number - anything other than Integer or
>Long Integer which will only show whole number.  

>[quoted text clipped - 13 lines]

>--
>Message posted via AccessMonster.c omhttp://www.accessmonst er.com/Uwe/Forums.aspx/databases-ms-access/2008...

--
Message posted via http://www.accessmonster.com