Number to fixed length string

[John]

Hi

Is there a way to convert an integer value into a string of length 8 with
extra places filled with spaces? Ideally I need it done in single step as I
need to use it in a query. I have looked through str and string functions
but can't see anything relevant.

Many Thanks

Regards

 

[Guest]

It would have helped if you would have provided some samples so we would know
if you want the spaces before or after the number. Assuming before, use an
expression like:
Right(" " & [IntegerValue],8)

 

[Guest]

strNumber8 = Space(8-Len(cstr(lngNbr))) & Cstr(lngNbr)