Custom Currency Format

[Ichigo]

Dear Friends,

I seem to have difficulty in setting a custom Currency format. I need to set my currency alignment to

RM000100.00
RM001000.00



I set "RM"* #,##0.00 in Access 2003 and it worked but the same custom code does not work for Access 2007. I tried it in another computer and it still cannot appear as above.

Is is a bug or is there a workaround for this? Thank you.

[aamer]

Try This

"RM "#,##0.00;"(RM "#,##0.00)

[Ichigo]

Hi Aamer,

Thanks for your contribution. Sad to say, the result remain the same. In Table view it still shows as follows
0RM 100
RM 1000

The idea is to align the currency symbol to the left and the value to the right so that even if my table width expands, both symbol & value will be align left and right justifiably as follows:

RM 00100
RM 01000

Thanks.

[Ichigo]

Hi friends,

Anyone has idea on how to custom format the currency as per earlier postings above? Thank you.