Format unbound field in form as currency

[Darko]

I have a simple table with StatusID, Company and Status fields. Status field
is payment status for the company and it is formated as currency. Now on a
simple form I want to be able to select from drop-down list a Company and
then to show in an unbound field the value of Status field. Thats not a
problem. I used Me![Status] = Me![Company].Column(2) and it works just fine.
The only problem is that I get a simple number in unbound field instead of
currency formated.
I need to show, for example:
-11.760,00 €
instead of:
-11760
I tried selecting Currency from unbound Status field Properties but it
didn't worked.
What I'm doing wrong?

 

[Ken Snell \(MVP\)]

Try this VBA code to explicity declare the data value as a curency type:

Me![Status] = CCur(Me![Company].Column(2))