Q:

How can i get the proper format for series using label?

just wondering about my problem in making series numbers . Does someone knows about this?
Dim series As String = "0000"
Dim adds As New SqlCommand("Select MAX (IR_No) from IR_ActionTaken",conn)

conn.Open()
Form43.label_irno.Text = Format("00000", adds.ExecuteScalar() + 1)
conn.Close()

A:

You can use String.padLeft specifying total length you would like. For example, following c# code snippet keeps total string length 20 and adjust the padding according to the actual string length.
Dim myString as String 
myString = "Hello World!"
debug.print(myString.PadLeft(20,"-")

