Question Formating Currency to plain numbers? (1 Viewer)

[travel4u]

Hello PRO's,

How to format to get results I want from Currency field?
I need with leading zeros and without cent separator total of 8 digits:
[CurrencyField] -> What I want to see on separate (unbound) text box:
15,29 € -> 00001529
1458,80 € -> 00145880
etc.?
I have tried Format([CurrencyField];"00000000")

Thanks in advance.

 

[arnelgp]

use comma (,) on your expression instead of semicolon (


format(replace([currencyField] & ""; ",";""),"00000000")

 

[travel4u]

Sorry no.... In European version of Access we use ; instead of comma :/

 

[Gasman]

Can't you just multiply the value by 100 and format the control to 00000000 ?

 

[travel4u]

THANKS! That solved this