Formating a Field

H

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?
 
J

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
..
 
J

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?
Click to expand...

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?
 
Top