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 / Forms / April 2008

Tip: Looking for answers? Try searching our database.

Decimal Number

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
forcefield - 13 Apr 2008 13:32 GMT
Hi Everyone,
My problem is very simple and yet I could not solve this problem.
On my form is  a combo. The properties are as follows
Control source  :  Wqty  (which is bound to a number field in the table)
Format:  when I enter #0.00 it automatically change to Fixed
Decimal Places:  2
Row source type: Value list
Row source: 0.25, 1.25; 1.75; 2.00;

When I select 0.25 on the combo the value changes to 0.00
When I select 1.25 the value changes to 1.00
When I select 1.75 the value changes to 2.00

Can somebody please tell me what is wrong?
Rick Brandt - 13 Apr 2008 13:49 GMT
> Hi Everyone,
> My problem is very simple and yet I could not solve this problem.
[quoted text clipped - 10 lines]
>
> Can somebody please tell me what is wrong?

Look at the underlying table in design view.  Specifically the Data Type of
the Wqty field.  My guess is that it is currently set to "Number" with a
size of either Integer or Long Integer neither of which support fractional
values.

You would either need to change the size to Single or Double, or change the
Type to Currency or Decimal.  I prefer Currency because the Access
implementation of the Decimal type has a few issues.  Even if your data is
not "currency" you can still use that type and use formatting to eliminate
the dollar sign from view.

Also note that Single and Double are "imprecise" types meaning that the data
as stored can introduce rounding issues (what you enter or see is not
necessarily the actual value stored).  Currency and Decimal do not have that
issue.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com

 
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.