Removing the Auto Round feature for numbers?

Hi,

Can anyone tell me how to remove or change the automatic rounding of numbers in a box.
The box has already been tested with General Number, Fixed, and Standard Formatting
with the decimal place being selected for 2.

Ex. If I key the number 2.25, or 2.5, I get the result of 2 .
If I key the number 2.75, I get the result of 3 .

I have been looking everywhere, even doing some reading on the MS website, and cannot
figure out how to find the control for this. Any help on this matter would be greatly appreciated.

BTW, im using MS Office 2003

TIA .. TORQUE

re: Removing the Auto Round feature for numbers?

On Fri, 10 Mar 2006 19:14:38 -0500, TORQUE <Torque@home.org> wrote:
[color=blue]
>Hi,
>
>Can anyone tell me how to remove or change the automatic rounding of numbers in a box.
>The box has already been tested with General Number, Fixed, and Standard Formatting
>with the decimal place being selected for 2.
>
>Ex. If I key the number 2.25, or 2.5, I get the result of 2 .
> If I key the number 2.75, I get the result of 3 .
>
>I have been looking everywhere, even doing some reading on the MS website, and cannot
>figure out how to find the control for this. Any help on this matter would be greatly appreciated.
>
>BTW, im using MS Office 2003
>
>TIA .. TORQUE[/color]

What is the data type of the underlying field in your table?
It sounds like you may be using integer or long integer which do not allow
decimal places.


Wayne Gillespie
Gosford NSW Australia

re: Removing the Auto Round feature for numbers?

On Sat, 11 Mar 2006 01:20:12 GMT, Wayne Gillespie <bestfit@NOhotmailSPAM.com.au> wrote:
[color=blue]
>On Fri, 10 Mar 2006 19:14:38 -0500, TORQUE <Torque@home.org> wrote:
>[color=green]
>>Hi,
>>
>>Can anyone tell me how to remove or change the automatic rounding of numbers in a box.
>>The box has already been tested with General Number, Fixed, and Standard Formatting
>>with the decimal place being selected for 2.
>>
>>Ex. If I key the number 2.25, or 2.5, I get the result of 2 .
>> If I key the number 2.75, I get the result of 3 .
>>
>>I have been looking everywhere, even doing some reading on the MS website, and cannot
>>figure out how to find the control for this. Any help on this matter would be greatly appreciated.
>>
>>BTW, im using MS Office 2003
>>
>>TIA .. TORQUE[/color]
>
>What is the data type of the underlying field in your table?
>It sounds like you may be using integer or long integer which do not allow
>decimal places.
>
>
>Wayne Gillespie
>Gosford NSW Australia[/color]

Hi Wayne,

I have no clue what it was, I went into the design of the table and changed the properties from Number to Text for now.
So far I am able to put in .25, .50, .75, and it seems to be working. I really need to find out how to change it just in case
it does not allow me to perform what i need it to, being a text field instead of a number field.

Thanks,
Torque

re: Removing the Auto Round feature for numbers?

On Sat, 11 Mar 2006 00:13:50 -0500, TORQUE <Torque@home.org> wrote:
[color=blue]
>On Sat, 11 Mar 2006 01:20:12 GMT, Wayne Gillespie <bestfit@NOhotmailSPAM.com.au> wrote:
>[color=green]
>>On Fri, 10 Mar 2006 19:14:38 -0500, TORQUE <Torque@home.org> wrote:
>>[color=darkred]
>>>Hi,
>>>
>>>Can anyone tell me how to remove or change the automatic rounding of numbers in a box.
>>>The box has already been tested with General Number, Fixed, and Standard Formatting
>>>with the decimal place being selected for 2.
>>>
>>>Ex. If I key the number 2.25, or 2.5, I get the result of 2 .
>>> If I key the number 2.75, I get the result of 3 .
>>>
>>>I have been looking everywhere, even doing some reading on the MS website, and cannot
>>>figure out how to find the control for this. Any help on this matter would be greatly appreciated.
>>>
>>>BTW, im using MS Office 2003
>>>
>>>TIA .. TORQUE[/color]
>>
>>What is the data type of the underlying field in your table?
>>It sounds like you may be using integer or long integer which do not allow
>>decimal places.
>>
>>
>>Wayne Gillespie
>>Gosford NSW Australia[/color]
>
>Hi Wayne,
>
>I have no clue what it was, I went into the design of the table and changed the properties from Number to Text for now.
>So far I am able to put in .25, .50, .75, and it seems to be working. I really need to find out how to change it just in case
>it does not allow me to perform what i need it to, being a text field instead of a number field.
>
>Thanks,
> Torque[/color]


The property should be Number in the top section of the table design and in the
lower section (Field Size) you set the type of Number field you want. If you
require decimal places the Field Size should be set to Single or Double. If you
do not required decimal places set the Field Size to Integer, Long Integer or
Byte.


Wayne Gillespie
Gosford NSW Australia

re: Removing the Auto Round feature for numbers?

On Sat, 11 Mar 2006 05:25:01 GMT, Wayne Gillespie <bestfit@NOhotmailSPAM.com.au> wrote:
[color=blue]
>On Sat, 11 Mar 2006 00:13:50 -0500, TORQUE <Torque@home.org> wrote:
>[color=green]
>>On Sat, 11 Mar 2006 01:20:12 GMT, Wayne Gillespie <bestfit@NOhotmailSPAM.com.au> wrote:
>>[color=darkred]
>>>On Fri, 10 Mar 2006 19:14:38 -0500, TORQUE <Torque@home.org> wrote:
>>>
>>>>Hi,
>>>>
>>>>Can anyone tell me how to remove or change the automatic rounding of numbers in a box.
>>>>The box has already been tested with General Number, Fixed, and Standard Formatting
>>>>with the decimal place being selected for 2.
>>>>
>>>>Ex. If I key the number 2.25, or 2.5, I get the result of 2 .
>>>> If I key the number 2.75, I get the result of 3 .
>>>>
>>>>I have been looking everywhere, even doing some reading on the MS website, and cannot
>>>>figure out how to find the control for this. Any help on this matter would be greatly appreciated.
>>>>
>>>>BTW, im using MS Office 2003
>>>>
>>>>TIA .. TORQUE
>>>
>>>What is the data type of the underlying field in your table?
>>>It sounds like you may be using integer or long integer which do not allow
>>>decimal places.
>>>
>>>
>>>Wayne Gillespie
>>>Gosford NSW Australia[/color]
>>
>>Hi Wayne,
>>
>>I have no clue what it was, I went into the design of the table and changed the properties from Number to Text for now.
>>So far I am able to put in .25, .50, .75, and it seems to be working. I really need to find out how to change it just in case
>>it does not allow me to perform what i need it to, being a text field instead of a number field.
>>
>>Thanks,
>> Torque[/color]
>
>
>The property should be Number in the top section of the table design and in the
>lower section (Field Size) you set the type of Number field you want. If you
>require decimal places the Field Size should be set to Single or Double. If you
>do not required decimal places set the Field Size to Integer, Long Integer or
>Byte.
>
>
>Wayne Gillespie
>Gosford NSW Australia[/color]


Thanks Wayne ....

Torque

re: Removing the Auto Round feature for numbers?

Single for one digit after the decimal;
Double for two;
Float for three or more (beers).

re: Removing the Auto Round feature for numbers?

Ex. If I key the number 2.25, or 2.5, I get the result of 2 .
If I key the number 2.75, I get the result of 3 .

if u have change the format to double

and u still want to change the number from 2.25 -->
consider using "update query" with "round" function

regards