Print Number as Currency

[szw...@hapit.nl]

I have a form with various amounts where I want to have a currency symbol printed before. The format of all these database fields is N12.2C.

In the BindFormat I have now set: Currencies.Currency_symbol + " " + "N12.2C". This prints the currency symbol before the amount, but always takes into account 12 digits before the decimal point. That is usually not the case. How do I get only 1 space between the currency symbol and the amount?

Thanks for your help!

Regards, Simone

[Noam Honig]

Try "N12.2CL"

Noam Honig  

Founder & CEO

www.fireflymigration.com

--
You received this message because you are subscribed to the Google Groups "Migrated By Firefly" group.
To unsubscribe from this group and stop receiving emails from it, send an email to migrated-by-fir...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/migrated-by-firefly/92a71bc7-8795-4bbb-823c-286fe2126c20n%40googlegroups.com.

[szw...@hapit.nl]

Perfect!! Thanks Noam.