Convert to Text "As is"

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top