var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: padding with leading zeros
I have an Access query, that I need to export as a fixed length file. I need some fields to be padded with leading zeros to export the file with the correct fields at the correct length.
How can I pad these integer fields with leading zeros? Please help!
Where the number of zeros is the total desired length.
You could also use the String function. You pass the number of times to repeat the character and the character to repeat and concatenate that to your field. Like yourField = String(5, "0") & Field1.
Just remember that yourField will now be a string type.
Originally Posted by pbaldy
Thanks...I used a verion of this!