[AccessD] Format Valuta

Hello Thanks for the answers already,

but suddenly i remembert a similar question from me a few months ago.
Gustav Brock then suggested            ........ , "currency").
I tried this and it works.
What i don't understand, why is "Valuta" working on a unbound textbox as
control source, but doesn't work in the if statement in code????

Pedro


----- Original Message -----
From: "Pedro Janssen" <pedro at plex.nl>
To: <AccessD at databaseadvisors.com>
Sent: Wednesday, December 03, 2003 10:45 PM
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
>
>
>