alter second currency display

[kevster]

I am displaying product prices in £s and Euros but want to tweak the Euros display part from:

£4.99 [€7.50] to:

£4.99 [approx €7.50]

Is this an easy tweak, I've looked in Act_productPrice.html but this is no good?

Thanks, Kevin

[kevster]

bump bump bump

[NormanRouxel]

You'll need Access 2000 or later. Open ActinicCatalog.mdb (back it up first). Look in the Setup2 table for the sEuroPriceFormat field. It should be

%s [%s]

change to

%s [approx %s]

[NormanRouxel]

Warning. You may need to redo this if you go into Design / Options / Misc. I can't find where actual the list of formats is kept.

[kevster]

Many thanks Norman - did the trick. Good that it does not affect the cart pages pricing as this would look messy.

Kevin

[NormanRouxel]

Good that it does not affect the cart pages pricing as this would look messy.

I'm surprised that it didn't. I'm pretty sure that this is a global format.

Just checked further and it will take over when you do a Refresh.

There's a fix. Edit ActinicOrder.pm and search for

		$sFormattedPrice = sprintf($$::g_pSetupBlob{'EURO_FORMAT'}, $sFormattedPrice, $sAltPricePrice);

change to

		$sFormattedPrice = sprintf('%s [%s]', $sFormattedPrice, $sAltPricePrice);

You can change the '%s [%s]' as required (as long as you keep the two %s bits intact.