Five spaces followed by a numeric value? Try:
" " & MyValue

This may not give you what you want if the value is, say, greater than 9,
but then you do not have a good history for expressing your questions
clearly, nor, indeed, for showing gratitude for the learned advice you do
receive.

--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

"00Eric Clapton" wrote in message
...
And how I change a field with value 1 to " 1" with leading 5 empty
space and string datatype?


"00Eric Clapton" wrote in message
...
What is the function which can convert date field to string in a specific
format? Thanks.