Convert to Text "As is"

  • Thread starter Warren Phillips
  • Start date
W

Warren Phillips

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
 
F

freakazeud

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
 
Top