Problem with HREF and Currency Format in same table

[Chad]

I added a Hyperlink to a magic cell (mc2) and the column is unaffected by the code. The Hyperlink works
fine if mc1 is remarked out, but then the currency format quits working. Any suggestions would be great.
Thanks,
Chad

fm = "format=[currency]"
mc1 = "(;|[]@)"
mc2 = &#34;CLIN,,<A HREF=Chart.asp?PC=#PercentComplete#&Schedule=#Sche dule# TARGET=NEW>#CLIN#</A>;&#34;
mc3 = &#34;Funded | align=right| $format=[###,###,###.00];&#34;
mc4 = &#34;Committed | align=right| $format=[###,###,###.00];&#34;
mc = mc1 & mc2 & mc3 & mc4
MyDb.dbMagicCell = mc

[Chad]

Still doesn&#39;t work. It now puts #CLIN# in the CLIN column and doesn&#39;t pass the variables to the
HREF tag.


------------
Mark at 4/9/01 3:18:09 PM

Chad,

Use:
CLIN||
instead of
CLIN,,

Mark.


------------
Chad at 4/9/01 3:13:54 PM

I added a Hyperlink to a magic cell (mc2) and the column is unaffected by the code. The Hyperlink works
fine if mc1 is remarked out, but then the currency format quits working. Any suggestions would be great.
Thanks,
Chad

fm = &#34;format=[currency]&#34;
mc1 = &#34;(;|[]@)&#34;
mc2 = &#34;CLIN,,<A HREF=Chart.asp?PC=#PercentComplete#&Schedule=#Sche dule# TARGET=NEW>#CLIN#</A>;&#34;
mc3 = &#34;Funded | align=right| $format=[###,###,###.00];&#34;
mc4 = &#34;Committed | align=right| $format=[###,###,###.00];&#34;
mc = mc1 & mc2 & mc3 & mc4
MyDb.dbMagicCell = mc

[Mark]

Chad ,
I see that you also redefined the Field delimiter to &#34;@&#34;
So, use:
@CLIN@ instead of #CLIN#

Mark.


------------
Chad at 4/9/01 3:30:36 PM

Still doesn&#39;t work. It now puts #CLIN# in the CLIN column and doesn&#39;t pass the variables to the
HREF tag.


------------
Mark at 4/9/01 3:18:09 PM

Chad,

Use:
CLIN||
instead of
CLIN,,

Mark.


------------
Chad at 4/9/01 3:13:54 PM

I added a Hyperlink to a magic cell (mc2) and the column is unaffected by the code. The Hyperlink works
fine if mc1 is remarked out, but then the currency format quits working. Any suggestions would be great.
Thanks,
Chad

fm = &#34;format=[currency]&#34;
mc1 = &#34;(;|[]@)&#34;
mc2 = &#34;CLIN,,<A HREF=Chart.asp?PC=#PercentComplete#&Schedule=#Sche dule# TARGET=NEW>#CLIN#</A>;&#34;
mc3 = &#34;Funded | align=right| $format=[###,###,###.00];&#34;
mc4 = &#34;Committed | align=right| $format=[###,###,###.00];&#34;
mc = mc1 & mc2 & mc3 & mc4
MyDb.dbMagicCell = mc

[Chad]

I removed the &#34;@&#34; field delimeter and it works fine now.
Thanks for the help,
Chad


------------
Mark at 4/9/01 3:35:12 PM

Chad ,
I see that you also redefined the Field delimiter to &#34;@&#34;
So, use:
@CLIN@ instead of #CLIN#

Mark.


------------
Chad at 4/9/01 3:30:36 PM

Still doesn&#39;t work. It now puts #CLIN# in the CLIN column and doesn&#39;t pass the variables to the
HREF tag.


------------
Mark at 4/9/01 3:18:09 PM

Chad,

Use:
CLIN||
instead of
CLIN,,

Mark.


------------
Chad at 4/9/01 3:13:54 PM

I added a Hyperlink to a magic cell (mc2) and the column is unaffected by the code. The Hyperlink works
fine if mc1 is remarked out, but then the currency format quits working. Any suggestions would be great.
Thanks,
Chad

fm = &#34;format=[currency]&#34;
mc1 = &#34;(;|[]@)&#34;
mc2 = &#34;CLIN,,<A HREF=Chart.asp?PC=#PercentComplete#&Schedule=#Sche dule# TARGET=NEW>#CLIN#</A>;&#34;
mc3 = &#34;Funded | align=right| $format=[###,###,###.00];&#34;
mc4 = &#34;Committed | align=right| $format=[###,###,###.00];&#34;
mc = mc1 & mc2 & mc3 & mc4
MyDb.dbMagicCell = mc