Formatting Issue 1

[TBOB]

Trying to format the variable LINENUM with the following code:

strLINETYPE = "W"
strLINENUM = "1234567"

Case 8
strLINENUM = Format(strLINENUM, "\A\B\C\D-" & strLINETYPE & "-@@@@@-@@")

This is resulting with this:
"ABCD-5-@@@@@-@@"

Should be this:
"ABCD-W-12345-67

I use this format with other LINENUM cases and the formatting works out fine. It only seems to have a problem when the LINETYPE is a "W". When I hover over strLINETYPE after it is initialized it is a "W". Any Suggestions?

Thanks,

Tony

 

[Remou]

I think you need another slash (\):
strLINENUM = Format(strLINENUM, "\A\B\C\D-[red]\[/red]" & strLINETYPE & "-@@@@@-@@")

 

[TBOB]

Remou,

Your the man! That did it.

Thanks,

Tony