John Colby
jwcolby at ColbyConsulting.com
Fri Oct 21 14:51:55 CDT 2005
OK, so how do you handle this when you format a currency string? John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Friday, October 21, 2005 2:57 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Data Export Spec - Rev1 Hi John No, we can use Format() just fine. It's just that you can't rely on it for formatting decimals when exporting to a text file as the specs for this will require one specific format (say dot for the decimal point which is quite often used for mainframes) while Format() will deliver whatever is set on the user's machine. /gustav >>> jwcolby at ColbyConsulting.com 21-10-2005 17:25 >>> Gustav, I am assuming that the format$() will work just fine assuming that you are using this in Denmark, then the strings you use to format allow you to use Danish formatting constructs? Are you saying that you cannot use Format$() because it doesn't work anywhere but the US? If that is the case, then people outside of the US will need to work with the team to explain how you guys accomplish formatting. John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Friday, October 21, 2005 10:39 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Data Export Spec - Rev1 Hi John You would need to address the good old internationalization task here as well. Over here, this example will output $23.423,00 ... /gustav >>> jwcolby at ColbyConsulting.com 21-10-2005 15:56 >>> For example, if a field needs to be currency, placing the format$ "$###,###.00" gives an output in the text string of $23,423.00, etc etc. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com