decimals in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have a form based on a query

In that form I display a field. Properties of that field in the form are decimal number = 2 and standard number
In the table I select viq the query, the field has also decimal number = 2

When I put in data directly in the table ex. 2,3 It change it to 2. I want the 2,3. How it comes?

I have the same problem in my form

Thanks
Jac
 
You probably selected the wrong Field Size in the DesignView of the Table.
If you selected Long, Integer or Byte which store whole numbers, Access will
round the numbers before storing.


To store decimals, you need to select Single, Double or Decimal.

--
HTH
Van T. Dinh
MVP (Access)



Jac said:
Hi,

I have a form based on a query.

In that form I display a field. Properties of that field in the form are
Click to expand...
decimal number = 2 and standard number.
 
OPEN YOUR QUERY, WHEN YOU ARE IN THE DESIGN VIEW MAKE IT.

RIGHT CLICK IN THE FIELD THAT YOU WANT SET THE FORMAT, PROPERTIES, AND YOU
GOONA SEE THE FORMAT PROPERTIES AND DECIMAL PLACES. GOOD LOOK :-)
Jac said:
Hi,

I have a form based on a query.

In that form I display a field. Properties of that field in the form are
Click to expand...
decimal number = 2 and standard number.
 
Back
Top