Formating a Field

  • Thread starter Thread starter Hendrix10
  • Start date Start date
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?
 
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
..
 
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?
 
Back
Top