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?
