[AccessD] Format Valuta

When i set the textbox Format property i get no Euro sign as result.

Pedro




----- Original Message -----
From: "Heenan, Lambert" <Lambert.Heenan at AIG.com>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Wednesday, December 03, 2003 11:01 PM
Subject: RE: [AccessD] Format Valuta


> Any reason that you don't just set the textbox's Format property in the
> form's design view?
>
> > -----Original Message-----
> > From: Pedro Janssen [SMTP:pedro at plex.nl]
> > Sent: Wednesday, December 03, 2003 4: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
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>