Number field

T

Tony

In a number field I have created for a table it rounds
the decimal to the nearest whole number, yet I put 2
decimal places in the field properties.
 
C

Cheryl Fischer

Have you set the FieldSize property to one that accommodates decimal values?
For example, Double will accept decimal values; Integer and Long Integer
will not.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
How to count the numbers in a Word document? 0
Mail Merge - displaying a conditional number of decimals 5
How do I stop rounding of my calculation results. 6
rounding problems 11
Finding the proper style field and the numbered paragraph value within the style 0
Decimal places in forms 2
Form Rounds up Decimal numbers, WHY? 7

Top