|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 30th, 2008, 08:33 PM
posted to microsoft.public.access
|
|||
|
|||
decimal places
Hi
I have changed the number of decimal places to 2 in the database and in on the form and the decimal places still does not show. I tried to enter numbers with decimals directly in the database and on the form and the result is the same, each round up to the nearest whole number. What do I need to do? -- Thank-you! Ruth 
|
|
#2
January 30th, 2008, 08:39 PM
posted to microsoft.public.access
|
|||
|
|||
|
decimal places
"Ruth" wrote in message
... Hi I have changed the number of decimal places to 2 in the database and in on the form and the decimal places still does not show. I tried to enter numbers with decimals directly in the database and on the form and the result is the same, each round up to the nearest whole number. What do I need to do? Make sure that the Field Size of the field in question is not one of the whole-number types: Integer, Long Integer, or Byte. Those types can't store any decimal places, by definition. Use a Field Size of Single, Double, or Decimal, or a Field Type of Currency, to allow decimal places to be stored. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup)
|
|
#3
January 30th, 2008, 09:39 PM
posted to microsoft.public.access
|
|||
|
|||
|
decimal places
Thank-you very much!
-- Thank-you! Ruth "Dirk Goldgar" wrote: "Ruth" wrote in message ... Hi I have changed the number of decimal places to 2 in the database and in on the form and the decimal places still does not show. I tried to enter numbers with decimals directly in the database and on the form and the result is the same, each round up to the nearest whole number. What do I need to do? Make sure that the Field Size of the field in question is not one of the whole-number types: Integer, Long Integer, or Byte. Those types can't store any decimal places, by definition. Use a Field Size of Single, Double, or Decimal, or a Field Type of Currency, to allow decimal places to be stored. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup)
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
