[AccessD] Padding text values

Right -- :) 

I'm just remembering something incorrectly Stuart -- I do it all the time.
:) 

Susan H. 

Leading zeros formatting only works with numeric values.
One way to pad a text field that contains only numerics is
Format$(val(strText),"0000")