[AccessD] Padding text values

 Format(str, "00#") - that is :)


-----Original Message-----
From: Steve Conklin [mailto:developer at ultradnt.com] 
Sent: Monday, January 16, 2006 2:25 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Padding text values

Format(str, 00#) 

Hth
Steve 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Monday, January 16, 2006 2:18 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Padding text values

I thought I could pad a text value with a simple expression in Format or
Default, but can't come up with it -- I know I could write a function to do
this, but seems this should be a simple property expression. I don't want to
force the user to enter 045 instead of 45 -- I want to add the leading zero.
I'm pulling a complete blank. 
 
Susan H. 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com