Sort on number ads 0

Catalina

Registered User.
Local time
Yesterday, 16:08
Joined
Feb 9, 2005
Messages
471
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
 
Go to the textbox (or whichever control it is) on the form, and look for the Format property. Do the same thing for the query that's bound to the form (if it applies).
 

Users who are viewing this thread

Back
Top Bottom