[AccessD] Format Valuta

The "EUR##000.00" is wrong, the clipboard modified it, I didnt 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]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]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
Website: http://www.databaseadvisors.com