access removes my 0 at the start of the number

[Jimmyboy]

How do you resolve this issue, its been driving me nuts for an hour. Cant you just format the cell-column to accept 0s as part of a number?

 

[DCrake]

Simple Software Solutions

Either convert the field to a text field or use the format
Format(Yourfield,"000000")

 

[raskew]

True numbers don't start with 0. Converting to a text field will solve the display issue but will require additional steps if you're doing math with the number. The format(x, "000") to display the number with a leading zero works, provided you know the length of the number. This could create a labor-intensive hassle if, for example, you have a column with numbers of varying length.

Bob

 

[Jimmyboy]

many thanks to both of you for your info, i'll convert to a text field because it is independent to the rest of the database. Cheers from Spain.

 

[gemma-the-husky]

if it is a part number (say) that starts with a zero, then it probably REALLY is text

one benefit of having consistent length numeric strings (if you like) is that sorts work correctly

ie 01
02
...
10
11

rather than

1
10
11
...
2
20
21

which is always a bind to deal with!

 

[Jimmyboy]

cheers dude, i changed it to text and now it works fine!