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

Format function call may have four parts of its second parameter - format
expression:

Positive;Negative;Zero;Null

?format(503.21,"#0.00;(#0.00);---;(NONE)")
503.21
?format(-503.21,"#0.00;(#0.00);---;(NONE)")
(503.21)
?format(0,"#0.00;(#0.00);---;(NONE)")
---
?format(Null,"#0.00;(#0.00);---;(NONE)")
(NONE)

Shamil

----- Original Message ----- 
From: "Susan Harkins" <harkinsss at bellsouth.net>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Wednesday, January 18, 2006 11:08 PM
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