[AccessD] OT: Currency Display

MartyConnelly martyconnelly at shaw.ca
Fri Mar 11 15:17:41 CST 2005


 This is a lot easier to handle in VB.net
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemglobalizationregioninfoclassisocurrencysymboltopic.asp
with
System.Globalization.RegionInfo Class
 CurrencySymbol
ISOCurrencySymbol
Here is a list of all the currency symbols three characters
ISO 4217 Currency names and code elements

http://www.iso.org/iso/en/prods-services/popstds/currencycodeslist.html?printable=true

Erwin Craps - IT Helps wrote:

>Had to do this many times in W95/98 with early EURO migrations....  
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
>- Beach Access Software
>Sent: Friday, March 11, 2005 3:12 PM
>To: Access Developers discussion and problem solving
>Subject: Re: [AccessD] OT: Currency Display
>
>Erwin:
>
>I can't believe it.  It works!  What a dope I feel like!  Who'd have
>believed that they'd implement a not in list for that field?
>
>Anyway.  Thanks.  That solves a big problem.
>
>Regards,
>
>Rocky Smolin
>Beach Access Software
>http://www.e-z-mrp.com
>858-259-4334
>
>----- Original Message -----
>From: "Erwin Craps - IT Helps" <Erwin.Craps at ithelps.be>
>To: "Access Developers discussion and problem solving" 
><accessd at databaseadvisors.com>
>Sent: Friday, March 11, 2005 12:52 AM
>Subject: RE: [AccessD] OT: Currency Display
>
>
>  
>
>>I know
>>But dont click on the combo box,  just type any text you want in the
>>field...
>>
>>-----Original Message-----
>>From: accessd-bounces at databaseadvisors.com
>>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky
>>    
>>
>Smolin
>  
>
>>- Beach Access Software
>>Sent: Friday, March 11, 2005 1:01 AM
>>To: Access Developers discussion and problem solving
>>Subject: Re: [AccessD] OT: Currency Display
>>
>>Erwin:
>>
>>The button next to the language selection is labeled Customize and
>>    
>>
>opens
>  
>
>>a dialog box where you can select a currency symbol from a combo box,
>>but that only shows R, $ and the euro symbol.  No option on my system
>>    
>>
>to
>  
>
>>input your own symbol. Do you have that option on your system?
>>
>>Thanks and Regards,
>>
>>Rocky Smolin
>>Beach Access Software
>>http://www.e-z-mrp.com
>>858-259-4334
>>
>>----- Original Message -----
>>From: "Erwin Craps - IT Helps" <Erwin.Craps at ithelps.be>
>>To: "Access Developers discussion and problem solving"
>><accessd at databaseadvisors.com>
>>Sent: Thursday, March 10, 2005 1:46 PM
>>Subject: RE: [AccessD] OT: Currency Display
>>
>>
>>    
>>
>>>In the regional settings you can choose English sout Africa and you
>>>      
>>>
>>will
>>    
>>
>>>have a R as prefix.
>>>If you really want RSh you can click on the buttom next to it
>>>      
>>>
>>(change?)
>>    
>>
>>>and just type anything you want in curency symbol...
>>>However, this would be necesary on every computer.
>>>
>>>Erwin
>>>
>>>-----Original Message-----
>>>From: accessd-bounces at databaseadvisors.com
>>>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky
>>>      
>>>
>>Smolin
>>    
>>
>>>- Beach Access Software
>>>Sent: Thursday, March 10, 2005 10:13 PM
>>>To: Access Developers discussion and problem solving
>>>Subject: Re: [AccessD] OT: Currency Display
>>>
>>>What I may have to do is add a new option to my Preferences form -
>>>Currency symbol.  Ack.
>>>
>>>Rocky
>>>
>>>----- Original Message -----
>>>From: "MartyConnelly" <martyconnelly at shaw.ca>
>>>To: "Access Developers discussion and problem solving"
>>><accessd at databaseadvisors.com>
>>>Sent: Thursday, March 10, 2005 10:00 AM
>>>Subject: Re: [AccessD] OT: Currency Display
>>>
>>>
>>>      
>>>
>>>>Or maybe a display format like
>>>>
>>>>#,00"RSh"; -#,00"RSh"
>>>>
>>>>Rocky Smolin - Beach Access Software wrote:
>>>>
>>>>        
>>>>
>>>>>Dear List:
>>>>>
>>>>>This is really a Windows question, I believe.
>>>>>I have a prospect in Kenya who needs the currency fields to display
>>>>>          
>>>>>
>>>RSh
>>>      
>>>
>>>>>instead of $.  In the regional and language settings there are
>>>>>          
>>>>>
>>several
>>    
>>
>>>>>selections for English, like Zimbabwe which displays Z$ for the
>>>>>          
>>>>>
>>>currency
>>>      
>>>
>>>>>field.  You can also customize the currency symbol but only $ and
>>>>>          
>>>>>
>the
>  
>
>>>euro
>>>      
>>>
>>>>>symbol are in my combo box.
>>>>>
>>>>>Does anyone know how to customize this setting so I can display RSh?
>>>>>
>>>>>MTIA,
>>>>>
>>>>>Rocky Smolin
>>>>>Beach Access Software
>>>>>http://www.e-z-mrp.com
>>>>>858-259-4334
>>>>>
>>>>>          
>>>>>
>>>>-- 
>>>>Marty Connelly
>>>>Victoria, B.C.
>>>>Canada
>>>>
>>>>
>>>>
>>>>-- 
>>>>AccessD mailing list
>>>>AccessD at databaseadvisors.com
>>>>http://databaseadvisors.com/mailman/listinfo/accessd
>>>>Website: http://www.databaseadvisors.com
>>>>
>>>>        
>>>>
>>>-- 
>>>AccessD mailing list
>>>AccessD at databaseadvisors.com
>>>http://databaseadvisors.com/mailman/listinfo/accessd
>>>Website: http://www.databaseadvisors.com
>>>-- 
>>>AccessD mailing list
>>>AccessD at databaseadvisors.com
>>>http://databaseadvisors.com/mailman/listinfo/accessd
>>>Website: http://www.databaseadvisors.com
>>>
>>>      
>>>
>>-- 
>>AccessD mailing list
>>AccessD at databaseadvisors.com
>>http://databaseadvisors.com/mailman/listinfo/accessd
>>Website: http://www.databaseadvisors.com
>>-- 
>>AccessD mailing list
>>AccessD at databaseadvisors.com
>>http://databaseadvisors.com/mailman/listinfo/accessd
>>Website: http://www.databaseadvisors.com
>>
>>    
>>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada






More information about the AccessD mailing list