Hi,

I'm trying to format a string that is concatenated and I need leading zeros 3 digits total.

I've tried many different examples such as

& Format(strCount, "000")

which is fine if i want 000 every time. so this doesn't work. i could of just wrote strCount = "000" because when i add 1 to the count and format it, then it is back to 000.

Any simple ideas would be appreciated.