By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,105 Members | 1,040 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,105 IT Pros & Developers. It's quick & easy.

Bilingual amount formatting

P: n/a
Rog
Hi,

I have a bilingual report that should print amounts as 1,234.00 in the
English(US) part --which is no problem-- and as 1.234,00 in the French
part. My regional settings are US. How can I format the amounts in
the European way?

TIA,
Rog

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Rog wrote:
Hi,

I have a bilingual report that should print amounts as 1,234.00 in the
English(US) part --which is no problem-- and as 1.234,00 in the French
part. My regional settings are US. How can I format the amounts in
the European way?

TIA,
Rog


If you use *Named* formats "Currency", "Short Date", etc., then they will adjust
automatically to the regional settings on the computer. If you use explicit
formats like "$#.00" those will not follow regional settings.

If you need an explicit format that changes I suppose you could have code that
creates a string with the Format() command and the named format property
"Currency", then examine the results to determine what the regional settings are
and change the explicit format used appropriately. You could also provide a
user-settable value stored in a table that would let the user change the
"locale" and apply your format based on that.

Such changes applied during runtime do not persist so you would have to apply
them each time the report or form was used.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

P: n/a
Rog
Rick,

The problem is I can use Format(myamount, "#,###.##") for the US part
of the report, but for the French part Format(myamount, "#.###,##")
does not work. I suppose I could write code to create a string and
substitute comma for decimal point and vice versa.

Rog

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.