Convertion Numeric to Character

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

Guest

anyone know how to convert a numeric value into character format with fix length and fill in the blank spaces with zero.
I have an autonumber field in my table then I want to convert the auto number value in a format like this :

autonumber field conversion result
----------------------------------------------------
1 0000001
.... ...........
789 000789

thanks for the ideas
 
Gabriel,

Use the Format() function, like so...

Format([MyAutoNumber], "0000000")

The above expression will format your first example to seven characters as
follows: 0000001. To format your second example, use six zeros in the
expression:

Format([MyAugoNumber], "000000")


hth,

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


Gabriel said:
anyone know how to convert a numeric value into character format with fix
Click to expand...
length and fill in the blank spaces with zero.
I have an autonumber field in my table then I want to convert the auto
Click to expand...
number value in a format like this :
 
Back
Top