Leading zeros in a field 2

[ErnNJ]

Does any one know a way to put leading zeros in a field automatically? My employer wants a customer number field that is 8 numbers long and shows the zeros for empty spaces ( 00000001 ). I'm pretty sure I could figure a way to do it with VBA but I would rather put in the table design for simplicity. Thanks in advance.

 

[SgtJarrow]

In the format property in the table, just put 8 0s.....00000000. This will place any lead zeros necessary to make 8 places. Programming isn't a profession of choice.
It's a profession of calling...
"Hey Programmer, your application broke again!"

Robert L. Johnson III, A+, Network+, MCP
robert.l.johnson.iii@citi.com

 

[ErnNJ]

How embarrassingly easy. I was under the impression that Format referred only to the type of data (number, integer). That's what happens when you assume. Thanks again.