[AccessD] Padding text values

Stuart McLachlan stuart at lexacorp.com.pg
Mon Jan 16 15:32:59 CST 2006


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





More information about the AccessD mailing list