Expression Field; Format like Access???

  • Thread starter Thread starter Gerard
  • Start date Start date
G

Gerard

Hey all,
I have a situation where Mortgage ID's need to be
formatted with padded zeros. I am upgrading legacy code,
and the code is looking for a Mortgage ID with padded zeros
(00000008 not 8). In Access, in the Design mode of a
table, you can simply put 00000000 in the Format field and
all data entered will be padded. In SQL Server table
design, there is a Expression field, which I guess can
accomplish the same thing. I need someone to help me with
an expression to pad the data with zeros, everything I've
tried has not worked. This is for an autonumber/numeric
type field, not a text field. Thanks in advance for any
help.

Gerard

P.S. There is a box of recycled bits for the best post :)
 
I'm not sure you can apply that kind of format at the table level. However,
you can apply it in each form and report.
 
Back
Top