which number field setting will display leading zero's?

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" <admirableknight@aol.com> wrote in message
news:20031006061949.21232.00001080@mb-m13.aol.com...[color=blue]
> which number field setting will display leading zero's?[/color]

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?

In article <20031006093221.02537.00000893@mb-m23.aol.com>,
admirableknight@aol.com says...[color=blue]
> 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?
>[/color]

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!

On 06 Oct 2003 10:19:49 GMT in comp.databases.ms-access,
admirableknight@aol.com (AdmirableKnight) wrote:
[color=blue]
>which number field setting will display leading zero's?[/color]

Input mask or format property.

--
A)bort, R)etry, I)nfluence with large hammer.