I tried that... I used #NumberFormat(Trim(Get_Property_Details.Sale_Price), "999999999999999")# and it didn't throw an error, but it put about 4 blanks spaces in the form field.
-----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 6:53 PM To: CF-Talk Subject: RE: What is wrong with this? > The masking does work correctly if I have the *exact* number > of nines as the masked number has digits to the left of the decimal. > > But that's not going to work, because there's no way to tell > what number of digits there will be for any given property! Doesn't it work if you have more digits in the mask than in the actual value? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272447 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
