Convert to Text "As is"

[Guest]

I have data in a numeric field in an Access 2003 database that looks like:

035327148

How can I convert this to a "text" field...and have the data retain all 9
digits (including the leading zero)????

Thanks
Warren Phillips

 

[Guest]

Hi,
is the length of the digits always the same? Then you could just use the
format function e.g.:

Format([YourNumber],"000000")

If not then you might need to use the Cstr function in combination with
zeros in front of it.
HTH
Good luck