Re: can I change the format of each detail in a report based on the c.

From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: 02/17/05 

Date: Thu, 17 Feb 2005 13:30:48 +0800

Create a small lookup table to hold the possible currencies you cope with.
it will have 3 fields:
    CurrencyID Primary key
    CurFormat Text

The table will contain records such as:
    US Dollar $#,##0.00; ($#,##0.00)
    UK Pound £#,##0.00; (£#,##0.00)

Your main table will have fields:
    CurrencyID Foreign key to tblCurrency.CurrencyID
    Amount Actual amount (stored in Currency type field).

Include the lookup table in the query that is the RecordSource of your
report, so you have the CurFormat field. Then in the report, set the
ControlSource of your text box to:
    =Format([Amount], [CurFormat]) 

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Henry Michael Horton" <Henry Michael Horton@discussions.microsoft.com> 
wrote in message news:8506A828-179A-4A90-9377-0958B89C9A05@microsoft.com...
>I would like to change the currency format of values in report details 
>based
> on the country of origin, i.e. pd sterling or dollar signs, using the 
> country
> field to force the event, is there a VBA process to do this?

Relevant Pages

  • Re: time to provalue our money?
    ... To this litany of country names with currencies than have been ... which "won" two world wars at the cost of two ... Your basic point, however, is taken:  what once cost cents now costs ...
    (rec.collecting.coins)
  • Re: time to provalue our money?
    ... To this litany of country names with currencies than have been ... devalued you can add Germany, Argentina and, of course, the USA. ... usbuck is or will be abandoned shortly by many countries as a reserve ...
    (rec.collecting.coins)
  • Re: Easyjet admit HSR greener option?
    ... in a country other than the UK in Sterling, using a debit card drawn ... you use it to pay online in other currencies, ... always offered in the currency of the originating country. ... I'm *sure* I've paid for flights from other contries to ...
    (uk.railway)
  • RE: Record with multiple lines
    ... A country can be invoiced in many currencies and a currency can be tied to ... many countries. ... In my report I'll need it to show all currencies in one line item. ... So in my report I create a textbox b/c I want this data all in one field per ...
    (microsoft.public.access.queries)
  • Record with multiple lines
    ... A country can be invoiced in many currencies and a currency can be tied to ... many countries. ... In my report I'll need it to show all currencies in one line item. ... So in my report I create a textbox b/c I want this data all in one field per ...
    (microsoft.public.access.queries)