[AccessD] Padding text values

On 16 Jan 2006 at 14:33, Susan Harkins wrote:

> =========I'm writing about a function -- I just wanted to cover my but*. ;)
> I don't know if I just can't remember or if it isn't possible to handle
> leading zeros in a text field with a field property. 
> 

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



-- 
Stuart