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 6 20331
On Fri, 10 Mar 2006 19:14:38 -0500, TORQUE <To****@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
On Sat, 11 Mar 2006 01:20:12 GMT, Wayne Gillespie <be*****@NOhotmailSPAM.com.au> wrote: On Fri, 10 Mar 2006 19:14:38 -0500, TORQUE <To****@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
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
On Sat, 11 Mar 2006 00:13:50 -0500, TORQUE <To****@home.org> wrote: On Sat, 11 Mar 2006 01:20:12 GMT, Wayne Gillespie <be*****@NOhotmailSPAM.com.au> wrote:
On Fri, 10 Mar 2006 19:14:38 -0500, TORQUE <To****@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
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
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
On Sat, 11 Mar 2006 05:25:01 GMT, Wayne Gillespie <be*****@NOhotmailSPAM.com.au> wrote: On Sat, 11 Mar 2006 00:13:50 -0500, TORQUE <To****@home.org> wrote:
On Sat, 11 Mar 2006 01:20:12 GMT, Wayne Gillespie <be*****@NOhotmailSPAM.com.au> wrote:
On Fri, 10 Mar 2006 19:14:38 -0500, TORQUE <To****@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
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
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
Thanks Wayne ....
Torque
Single for one digit after the decimal;
Double for two;
Float for three or more (beers).
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: joeandtel |
last post by:
If I have a value that is 53.123499999, how can I round it to 53.12?
|
by: Nils Grimsmo |
last post by:
Why did round() change in Python 2.4?
$ python2.3
Python 2.3.5 (#2, Jun 19 2005, 13:28:00)
on linux2
>>> round(0.0225, 3)
0.023
>>> "%.3f" % round(0.0225, 3)
'0.023'
>>>
|
by: Chris Davoli |
last post by:
The folllowing will round to 526, but it should round to 527. It works
correctly for all other numbers, except for this one. Does anybody know of a
bug in Math.Round?
Dim ldecWater As Decimal =...
|
by: Lance Hoffmeyer |
last post by:
Is there an easy way to round numbers in an array?
I have
Test =
and want to round so the values are
print Test
|
by: vul |
last post by:
In VB6 there is Auto Increment check box in Project Properties, which allow
you have a new version every time you compile the project.
Is there any easy way to have this feature in VB 2005?
Some...
|
by: David Coleman |
last post by:
I am running VS 2003 and have applied SP1. (On WinXP SP2, .Net 1.1)
In the Command Window I get the following
? Math.Round(0.715, 2)
0.72
? Math.Round(0.725, 2)
0.72
? Math.Round(0.735, 2)...
|
by: S.Dickson |
last post by:
I had an access database that i use as an ordering system. I have a
form for entering customer details. When i add a new customer on the
form the customer number is an auto number that appears when...
|
by: kkmigas |
last post by:
Can some one explain if this can be fixed using php.ini settings ?
echo "round 20.545 -".round(20.545,2)."<br>";
echo "round 20.555 -".round(20.555,2)."<br>";
echo "number_format 20.545...
|
by: iKiLL |
last post by:
Hi All,
I am trying to Bulid Windows Mobile Forms Control with C# in VS2005 using
CF2.
On this control A lable is created and some text set for the control. My
problem is that i dont know how...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |