[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