Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / SQL Server / ADP / December 2005

Tip: Looking for answers? Try searching our database.

currency display in unbound field

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JEM - 02 Dec 2005 00:50 GMT
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
Thank you, it works!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.