Concatination/Zero fill

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 2000. I’m using VBA code in a module. Is there an
equivelant to 'string2 = Right(Space(4) & [rst1]![orgn], 4)’ that would fill
with zeros instead of spaces? Thank you for your help.
 
Right("0000" & rst1!Orgn,4)

or

Right(String(4,"0") & rst1!Orgn,4)

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
Back
Top