format function

[Michael SF]

I need to format a string like V92 into a 5 character long - filling in the
remaining 2 spots with spaces so that it looks like this

"V92 "

MUST be 5 characters long using " " as the dilimiter - any idea? - - doinig
this on a query not the raw data

 

[Douglas J. Steele]

If your string is always 3 characters, you can use [My3CharacterField] & "
" or [My3CharacterField] & Space$(2)

If your string has a variable number of characters, and you always want 5
characters, you can use Left$([MyField] & " ", 5) or Left$([MyField] &
Space$(5), 5)

 

[fredg]

I need to format a string like V92 into a 5 character long - filling in the
remaining 2 spots with spaces so that it looks like this

"V92 "

MUST be 5 characters long using " " as the dilimiter - any idea? - - doinig
this on a query not the raw data

=[FieldName] & space(5 - len([FieldName]))