save number 001 and so on in access database

[cybercus2]

Hi..
I want to save a number like 001 and so on in access database.
I've tried something like this but it didn't work
strSQL = "Insert into [User] (UserID) VALUES" & "(" & Format(strNewID, "0##") & ")"
The record always 1 2 3 and so on not 001 002 003 ...

[Killer42]

Hi..
I want to save a number like 001 and so on in access database.
I've tried something like this but it didn't work
strSQL = "Insert into [User] (UserID) VALUES" & "(" & Format(strNewID, "0##") & ")"
The record always 1 2 3 and so on not 001 002 003 ...

Numbers are just stored as a numeric amount, not as a specific format (such as your three digits). If you want to actually store them that way, you would have to put them in a Text field.

It's more likely, though, that what you need to do is simply store the value as a number, and format it when retrieved. You can set a format on the table field in Access, so that Access will display it that way. In VB, just format the number when you retrieve it from the table, before printing or displaying it.