Hi+ACE-
If you don+ALQ-t need to do any calculations with the value, maybe you
can set the datatype to text?
Or write this in the format for taht particular field (table design)
+ACI-000+ACI- (without the quotes) if you need to do calculations.
Hakan
-----Ursprungligt meddelande-----
Fr+AOU-n: Marios Adamantopoulos +AFs-mailto:mario+AEA-tonic.co.uk+AF0-
Skickat: den 28 juni 2001 15:49
Till: ASP Databases
+AMQ-mne: +AFs-asp+AF8-databases+AF0- Keeping the 0's
Is there a way to keep the 0's in a number like this 006, in MS-Access?
+AF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBf-
Marios Adamantopoulos
Web Developer
Tonic Design Limited
Studio 2, Church Studios
Camden Park Road
London NW1 9AY