[AccessD] more on that Format() to pad text values question

Susan,

How about something like Format(Nz(YourValue,0),"000")  Uses more than
just the Format() function, but should do the trick. 

HTH,
Don

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Wednesday, January 18, 2006 12:08 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] more on that Format() to pad text values question

A small problem that I've notices is that if the string being formatted
is
empty or null, Format() returns empty or null, which I understand.
However,
is there anyway to force Format() to return something? What if you need
000
instead of empty or null? I can come up with a function or expression
myself, I'm just wondering if I can use Format() to force the digits
instead? 
 
Susan H. 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com