I need to take 255.14 and make it a 7 character text field with leading zero's. I can't get the conversion to text right. It still recognizes the decimals and removes teh leading zeros. 255.14 to 0000255
I always use FORMAT to do what you want.
Example FORMAT([MyNumber],"0000000") would format 255.14 to a string like 0000255. FORMAT([MyNumber],"0000.00" Would format it as 0255.14 and
FORMAT([MyNumber]*100,"0000000") would format it like 0025514
FoFa isn't showing as online, so I'll point out the parentheses in his example and the lack of them in yours. Format() is a function, which you can find more info about in Help.
FoFa isn't showing as online, so I'll point out the parentheses in his example and the lack of them in yours. Format() is a function, which you can find more info about in Help.