Sort on number ads 0 (1 Viewer)

Catalina

Registered User.
Local time
Yesterday, 18:58
Joined
Feb 9, 2005
Messages
461
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
 

vbaInet

AWF VIP
Local time
Today, 02:58
Joined
Jan 22, 2010
Messages
26,374
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

Top Bottom