Formating a Field

[Hendrix10]

I have a field that shows up as 1234 but I need to add two zeros in
the middle so the field shows up as 120034. Is that possible? If so,
how would I do it?

 

[John Spencer]

You would have to user an expression like

Left([FieldName],2) & "00" & Mid([FieldName],3)

OR apply a format
Format("1234","@@\0\0")

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[John W. Vinson]

I have a field that shows up as 1234 but I need to add two zeros in
the middle so the field shows up as 120034. Is that possible? If so,
how would I do it?

More info please! Is this a Number field or a Text field? Will you ever do
calculations with this number, or is it just an identifier of some sort? Do
you want to just *display* the two zeros, or do you actually want to
permanently store the expanded value? Will the two zeros be editable later, or
will the two positions always be 00?