devxlogo

Adding Leading Zeroes

Adding Leading Zeroes

Question:
A control record value for next_order_num will contain the value “00009998” when you first get the control record file. Each time you write the next_order_num field back into the control record, I want the leading zeroes to be in place. For example, when you add 1 to “00009998”, it should write “00009999” into the control record as the next_order_num value.Please help me solve this problem.

Answer:
Before you add to the number, take the Val() of it. Add the appropriate value, and then use the Format$ function to put the leading zeroes back on. That’s the cleanest way to do it.

See also  Essential Measures for Safeguarding Your Digital Data
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist