Hello. In a combo box, i show the cost for the class which is a money
column. In the display of the combo box it shows fine: $250.00. But,
on my form, i have an unbound text box that displays the cost after a
class is chosen from the combo box. But, it is not displaying it
properly, it is showing 250. I formatted the text box as currency and
even tried using a custom format $###.00 but i still just get 250. Any
ideas?
giorgio rancati - 02 Dec 2005 12:07 GMT
Hi JEM.
Put in textbox's controlsource
----
=Ccur([ComboBox].[Column](1))
----
(check column number)
and put Currency in its Format properties
Bye

Signature
Giorgio Rancati
[Office Access MVP]
> Hello. In a combo box, i show the cost for the class which is a money
> column. In the display of the combo box it shows fine: $250.00. But,
[quoted text clipped - 4 lines]
>
> ideas?
JEM - 02 Dec 2005 17:40 GMT