|
| 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, 2006, 08:06 PM
posted to microsoft.public.access.reports
|
|||
|
|||
microsoft access formatting
formatting a data field in an access report to get rid of leading zeros
|
|
#2
January 30th, 2006, 08:29 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
microsoft access formatting
If the field consist of numbers only with leading zero's, you can try
val([FieldName]) or Format([FieldName],"#") -- \\// Live Long and Prosper \\// BS"D "Punky" wrote: formatting a data field in an access report to get rid of leading zeros
|
|
#3
January 30th, 2006, 08:29 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
microsoft access formatting
Please post an actual question using complete sentences.
One answer to your question (using as much detail as you gave us) would be... Change data type to numeric, not text. -- Rick B "Punky" wrote in message ... formatting a data field in an access report to get rid of leading zeros
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| microsoft word for free | aquina | General Discussion | 3 | September 22nd, 2005 11:41 PM |
| Images in a database | Franz | General Discussion | 10 | October 7th, 2004 09:35 AM |
| Access XP Compared to Access 2003 | Mardene Leahu | New Users | 1 | October 1st, 2004 05:11 AM |
| Troubleshoot the SendObject method | Nikky_Pickles | General Discussion | 1 | August 30th, 2004 07:40 AM |
| Error while running Access MDE | Hemil | General Discussion | 2 | June 21st, 2004 01:03 PM |
Linear Mode
