Random ID in Access

[J.B]

Hey all, my Access skills arent great but I know the basics. What Im looking at doing have an AutoNumber as an ID field, but needs to randomly generate. In the design view for the table I have set the field to AutoNumber and changed the new values to random. Trouble is it is generating numbers 10 digits long, is there anyway I can limit it to only generate 6 digit IDs?

 

[J.B]

I didnt write the brief! Its something to do with ananimity of the users, the users cant guess another users ID

 

[J.B]

Why not stick with the 10 digits Access gives you and just use the 6 first digits?

To validate the login the user will need to type in the full ID.

Looks like I'll have to stick with it, shame though, some our even coming as negative numbers!