[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