[AccessD] Format Valuta

lol!

 Outlook must be the one modifying the Euro symbol, I'm trying this time by sending the mail in HTML format.

Format("333.03","EUR##000.00")



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[ mailto:accessd-bounces at databaseadvisors.com <mailto:accessd-bounces at databaseadvisors.com> ]On Behalf Of David McAfee
Sent: Wednesday, December 03, 2003 2:34 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Format Valuta


The "EUR##000.00" is wrong, the clipboard modified it, I didn't catch it until my message came through. it should read as:

? Format("333.03","EUR##000.00")

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[ mailto:accessd-bounces at databaseadvisors.com <mailto:accessd-bounces at databaseadvisors.com> ]On Behalf Of David McAfee
Sent: Wednesday, December 03, 2003 2:18 PM
To: 'Access Developers discussion and problem solving'
Cc: 'pedro at plex.nl'
Subject: RE: [AccessD] Format Valuta


In a db that I distribute to my European distributors, I simply set the field format to Euro.

The following works in debug, so I couldn't see why you couldn't use it in a query:

? Format("333.03","EUR##000.00")

For your example:

Me.txtPrijs1 = Format([Forms]![frmExample]![txtTest], "EUR##000.00")

HTH
David McAfee

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[ mailto:accessd-bounces at databaseadvisors.com <mailto:accessd-bounces at databaseadvisors.com> ]On Behalf Of Pedro Janssen
Sent: Wednesday, December 03, 2003 1:45 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Format Valuta


Hello Group,

in an If statement i want to format a currency field so that the Euro sign is shown in an unbound textbox.

I tried:

If chbUitz = True Then
    Me!txtPrijs1 = Format([Forms]![frmExample]![txtTest], "Valuta")

Normally,    = Format([Forms]![frmExample]![txtTest], "Valuta")   
works as a control source.
Why doesnt it work now?

TIA


Pedro Janssen
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd <http://databaseadvisors.com/mailman/listinfo/accessd> 
Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com> 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd <http://databaseadvisors.com/mailman/listinfo/accessd> 
Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com>