425,705 Members | 1,852 Online
Need help? Post your question and get tips & solutions from a community of 425,705 IT Pros & Developers. It's quick & easy.

 P: n/a which number field setting will display leading zero's? Nov 12 '05 #1
4 Replies

 P: n/a None! Mathematically, there is no number that has (a) leading 0(s). 0, 1, 2,3 .... ad infinitum. If you want a numerical expression with leading 0s, you need to make it a text field. -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com "AdmirableKnight" wrote in message news:20***************************@mb-m13.aol.com... which number field setting will display leading zero's? Nov 12 '05 #2

 P: n/a I realise it doesnt feature in all number sets but for when listing Tel No's for example it would be handy . Would have thought its possible as its used in binary code? Nov 12 '05 #3

 P: n/a In article <20***************************@mb-m23.aol.com>, ad*************@aol.com says... I realise it doesnt feature in all number sets but for when listing Tel No's for example it would be handy . Would have thought its possible as its used in binary code? Dont confuse the storage of data and the display of the data. Two 100% separate things. Don't force the data you store to look like anything in particular that is irrelevant. Data Stored: PhoneNumber -> 123456 Data Displayed: Right("0000000" & PhoneNumber,7) Display Results: 0123456 -- http://www.Obscenitees.com These shirts are funny! Nov 12 '05 #4

 P: n/a On 06 Oct 2003 10:19:49 GMT in comp.databases.ms-access, ad*************@aol.com (AdmirableKnight) wrote: which number field setting will display leading zero's? Input mask or format property. -- A)bort, R)etry, I)nfluence with large hammer. Nov 12 '05 #5

### This discussion thread is closed

Replies have been disabled for this discussion.