Access 2013.
Table field is set to: Number/Byte, 0 decimals.
The field is used to sort records in a particular order.
In the form it is set to Standard, no Decimals and no Default Value.
When I create a new record and type in: 1, it makes it 10, 2 becomes 20 etc.
If I delete the value and type it in again, it does not ad the 0.
It only does it in the form, not when I enter it in the table directly.
Any ideas why this is happening?
Thanks
Table field is set to: Number/Byte, 0 decimals.
The field is used to sort records in a particular order.
In the form it is set to Standard, no Decimals and no Default Value.
When I create a new record and type in: 1, it makes it 10, 2 becomes 20 etc.
If I delete the value and type it in again, it does not ad the 0.
It only does it in the form, not when I enter it in the table directly.
Any ideas why this is happening?
Thanks