|
| 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
February 22nd, 2006, 02:27 PM
posted to microsoft.public.access
|
|||
|
|||
Designing Access tables
Why is my 2 decimal place formatting for a number field in Access not being
applied when I view the database? Still getting to 8 decimal places. Numbers cannot be formatted to 2 decimals in Excel either. 
|
|
#2
February 22nd, 2006, 02:31 PM
posted to microsoft.public.access
|
|||
|
|||
|
Designing Access tables
Well, what do you mean "when I view the database"? Are you viewing your
data in a form, report, or query? If a form or report, simply apply formatting and set decimal places to the number in the control's property box. -- Rick B "DG-Chesh" wrote in message ... Why is my 2 decimal place formatting for a number field in Access not being applied when I view the database? Still getting to 8 decimal places. Numbers cannot be formatted to 2 decimals in Excel either.
|
|
#3
February 22nd, 2006, 05:03 PM
posted to microsoft.public.access
|
|||
|
|||
|
Designing Access tables
Dear friend,
Try to set format to FIXED George Ο χρήστης "DG-Chesh" *γγραψε: Why is my 2 decimal place formatting for a number field in Access not being applied when I view the database? Still getting to 8 decimal places. Numbers cannot be formatted to 2 decimals in Excel either.
|
|
#4
February 22nd, 2006, 06:28 PM
posted to microsoft.public.access
|
|||
|
|||
|
Designing Access tables
Per DG-Chesh:
Why is my 2 decimal place formatting for a number field in Access not being applied when I view the database? Still getting to 8 decimal places. Numbers cannot be formatted to 2 decimals in Excel either. First place I'd look is your formatting. How about posting an example? -- PeteCresswell
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| What Are The Issues With MS Access Client to SQL Server DB | Smithers | General Discussion | 13 | January 9th, 2006 03:14 PM |
| Advice needed: Should we upgrade MS Access 2000? And if so to what? | ship | General Discussion | 43 | November 30th, 2005 10:58 PM |
| starting access 97 | Edward Letendre | General Discussion | 2 | January 26th, 2005 02:15 AM |
| Update/Append Access 2000 Tables | rdw1260 | General Discussion | 1 | September 7th, 2004 11:00 AM |
| Linking Access 97 tables to Access 2002 tables | michaelwoodard | Database Design | 2 | August 13th, 2004 02:43 AM |
Linear Mode
