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")