Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Visual Basic
Expertise: Beginner
Oct 1, 1996

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.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date