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
|
|||
|
|||
display fixed number
I have a table column named RATE as CURRENCY and set up as double, auto
decimal. I input number 1.4931. After save it, I change to decimal = 2. It display as: 1.49 but once you click this cell, it displays 1.4931. How to make this column display only 2 decimal for ever? |
#2
|
|||
|
|||
You'll need to prohibit the entry of more than 2 decimal places. You could
use an input mask to do this, or you could use programming in the form that is used for data entry to round to two decimal places before writing the data to the table. -- Ken Snell MS ACCESS MVP "accessfun" wrote in message ... I have a table column named RATE as CURRENCY and set up as double, auto decimal. I input number 1.4931. After save it, I change to decimal = 2. It display as: 1.49 but once you click this cell, it displays 1.4931. How to make this column display only 2 decimal for ever? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Problem with number format when exporting to fixed width | Burnsy | Running & Setting Up Queries | 2 | February 4th, 2005 09:39 PM |
Month([ArrivalDate]) not to display number month | Faio | General Discussion | 2 | January 8th, 2005 12:51 AM |
Reports To Display Number Beside Record | Eric R. Clark | Setting Up & Running Reports | 1 | December 21st, 2004 01:27 AM |
Restart Autonumber | Traci | New Users | 22 | July 21st, 2004 01:10 AM |
Display a number as text | Phil | Worksheet Functions | 3 | January 19th, 2004 05:47 AM |