zeros in front of field are dropped

[migaccess]

I created a table which primary key is unique number (6 in total), however if I enter for example 000005, it drops the zeros in front. How can fix this?
Thanks

[June7]

Change the field to a text type or keep the number type field and use Formatting to display with leading zeros.

[ssanfu]

Sounds like you defined the field type as integer or long integer.
You could change the field type to "Text" and set the field length to 6.

Having said that, PK fields of type TEXt are not really good as a PK field. See: http://www.fmsinc.com/free/newtips/primarykey.asp

[migaccess]

I have changed the field type to text.
Thanks