custom format (vb6)

[gdrezek]

Hi All,
I've got a bit of vb code in a dll. I thought everything was working well, but I've found out that it is formatting or not formatting a particular string correctly on one computer and not on another. The line is:

Format(Hex$(bpMacAddr(cnt)), "00")

In the "is working" instance it will take a hex number, say e, and will turn it to 0e.
In the "not working" instance it will take the same hex number and leave it as e.
This causes a lot of problems when I am trying to put together a MAC address and will return 00-0e-.....when working and returns 00-e-.....when it is not.

Why would this be so and how can I get around this.
Thank you.

gdr

[HansV]

The result of Hex$ is a text string, not a number, so you cannot expect formatting it as "00" to work consistently. Try this:

Right$("00" & Hex$(bpMacAddr(cnt)), 2)

[gdrezek]

Hi Hans,
Thank you.

<hr>expect formatting it as "00" to work consistently<hr>

Could you explain why it is not consistent? I knew that I was working with strings but I still thought I'd be able to format in the manner that I did thinking that if there were no character the formatting would be "forced" to place a zero there. After all it did work on the machine I developed it on, just not on the machine it was supposed to have worked on.
Thanks for a solution as well.

gdr

[HansV]

In fact, I don't know why it worked at all. A format such as "00" is a number format, not a text format. The result of Hex$ is text, not a number, so there is no reason why a number format should work.