Bilingual amount formatting - Microsoft Access / VBA

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

Subscribe Reply

1353

Rick Brandt

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

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

Similar topics

3264

Specifying a bilingual page title

by: Amittai Aviram | last post by:

This XHTML 1.0 Strict page -- http://www.studiolirico.org/docs/settimana2003.html has a bilingual title in Italian and English. The principle language of the page is Italian, so the <html> tag looks like this (w/o the space in the xmlns URL): <html xmlns="h ttp://www.w3.org/1999/xhtml" xml:lang="it" lang="it"> Within the body, I have English translations for all Italian text, and these are always contained within elements that bear the...

HTML / CSS

3531

Alignment to char and other things

by: Gustaf Liljegren | last post by:

I'm working with some semi-advanced tables with lots of decimal numbers in, and I can't get the alignment to work. http://www.algonet.se/~gustafl/temp/output_ib.html I want numbers aligned to the decimal point. The HTML 4 spec says User agents doesn't need to support 'char' and 'charoff', so I wonder if the problem is lack of support? If so, can the same results be achieved in another way?

HTML / CSS

1911

Bilingual site, best practice?

by: Tim | last post by:

I am doing a small asp webshop and want to make it atleast bi-lingual. I have thought of a few ways to do this but would like to have a second opinion on what you think is the best way. I have browsed the Google archives and seen this question pop up a few times before but never with any particulary good answers. For some reason this doesn't seem like a hot topic. I am not talking about the product information, that is already stored...

ASP / Active Server Pages

5940

access won't close after conditional formatting

by: Jouke Langhout | last post by:

Hello all! For quite some time now, I've got the following problem: Access won't close properly when a user closes the application. An ACCESS process stays active and that process can only be terminated by pressing ++ and then terminate the process. I searched the entire internet and found out that there could be two things wrong (both of them are mentioned in the bug list on the access

Microsoft Access / VBA

1376

formatting amount

by: mp | last post by:

I have an amount that I have to format to 9.2 example: 7564 should become 7564.00 Thanks in advance

C# / C Sharp

3311

Strategies for developing a bilingual website?

by: will | last post by:

I have a php/mysql site and I am wondering if anyone has suggestions about strategies for making it bilingual or resources on how to do this. I thought of one way which would be to replace the text with calls to a database which has all the text in it. But I would prefer to have a single file with phrases and then just be able to translate that single file into another language to produce a site in another language. Any ideas would be...

PHP

2306

AJAX Callback with large amount of text

by: eggie5 | last post by:

OK, so I'm trying to get a large amount of text back to my ASP script on the server. My large amount of text is the source to a web page, and I want to preserve the formatting on it, ie the indenting. Before any of this the only way I got stuff back to the server is with query strings. Now I'm pretty sure there's other ways to get data back to the sever besides query stings but I'm having trouble finding them. Can somebody point me in the...

Javascript

8278

How to format an amount of time > 24hr

by: Killer42 | last post by:

Hi all. I have a query which calculates the difference between two date/time fields. This returns a number which is, of course, useless without formatting (“I couldn’t believe it took 1.15740767796524E-05 to do that”). I have formatted this as "hh:nn:ss", and this works OK. But it clocks over at 24 hours, which effectively renders it useless for my purposes. Using "hhh:nn:ss" doesn't work. I forget the details, but it produced nonsense. ...

Microsoft Access / VBA

2326

currency formatting

by: sajitk | last post by:

Dear All, I am making a project using ASP.Net and C#. I have a text box where i enter the amount. What i want is that when the user goes to the next field, i want the amount to the formatted in the following way: For example, if the entered amount is 100000; i want it to be formatted as Rs. 1,00,000.00 This Rs. is for Indian Rupees. This can be US Dollors or Euro also.

C# / C Sharp

9708

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10588

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10324

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9161

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7623

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5527

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5662

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4302

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3827

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP