currency display in unbound field "JEM" <jennmertens[ at ]mindspring.com> 02.12.2005 00:50:30 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?

Re: currency display in unbound field "giorgio rancati" <giorgio_No_Spalmer_rancati[ at ]tiscali.it> 02.12.2005 12:07:07 Hi JEM. Put in textbox's controlsource ---- =Ccur([ComboBox].[Column](1)) ---- (check column number) and put Currency in its Format properties Bye -- Giorgio Rancati [Office Access MVP] "JEM" <jennmertens[ at ]mindspring.com> ha scritto nel messaggio news:1133484630.111388.271200[ at ]o13g2000cwo.googlegroups.com... [Quoted Text] > 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? >

Re: currency display in unbound field "JEM" <jennmertens[ at ]mindspring.com> 02.12.2005 17:40:11 Thank you, it works!