Form wont allow me to input a decimal figure

[optimus_1]

Afternoon

I have set up a table with the fields set as Long Integer and 2 decimal places. I have created a form to input into this field but for some reason the form will not allow me to input a decimal figure ie 1.50 etc..... When i input 0.50 it rounds it down to 0.

WHen going into the form design the field entry boxes are set as General Number and decimal places 2.

Does anyone know what im doing wrong?

Thanks
Nathan

 

[neileg]

An integer doesn't have decimal places. Change the field type to double.