text formatting

Cannot seem to find the cheat note… but … I need to convert record numbers to zero filled text strings; e.g. so that
record 1 become “0001”

yes, I know I’ve seen it but apparently my coffee level is low.

s = format( id, "0000" )

... = Format(yourNumber, "0000")