Control Source Formatting

[stevo1961]

Hi,

Hoping for any assistance here. I have the following in my control source which is the source for my ActiveX control or my barcode label text on my report.

=Code128("~212" & "00" & " 1 " & "" & "0123456" & " " & "999" & [DD] & " " & (4),1,True)

In Windows XP the control source works fine and the above control source formats [DD] field correctly below which is a
9 digit number.

(00) 1 0123456 999168697 4

But since we started using Windows 7 the formatting of [DD] barcode label text is not formatting correctly and giving me the following format for the field [DD]:

(00) 1 0123456 9994 4


Is there anyway I can correct this in Windows 7 or format [DD] to show the previous format as in Windows XP as 9 digit number

From this (00) 1 0123456 9994 4 to this (00) 1 0123456 999168697 4

Any help would be greatly appreciated,

 

[kjv1611]

Yuck. Sorry that's all I can think of right off-hand. I'd suggest searching online for variances between Windwos XP and Windows 7 on number formats and the like. I imagine you'll find there is some change specifically referencing your issue. If you can figure out the right search terms for that, then you should find the KB bulletin that hopefully or other documentation that exists, and then see if they have any recommendations. If they do not, and they at least give the differences, then perhaps you can find a way to code to that difference. And if you do code to the differences, you may need to have a condition to still handle it the way WinXP expects when run on WinXP, but otherwise use the new Win7 code.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57