No, you can't do that (althought it would be nice). The only thing I can think of ATM is formatting the number so that zero comes out as a space character.
Try this in your label expression: Format$(MyFieldName, " ") If the leading space in front of valid numbers is still a drama for you, then try this (replace i with your field name): Right$(format$(i," ") , len(format$(i, " "))-1) It's a bit of a dragon, but will do the trick. Cheers, Peter Zyczynski -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony Baylis Sent: Wednesday, 18 January 2006 2:35 PM To: Mapinfo-L Subject: [MI-L] Labelling numeric fields Afternoon all I have a large table with a numeric field I need to label BUT it contains many zero values. I do not wish to label the zeroes. Can you use an expression in the label tool such as: If FIELD>0 Then FIELD If this does not work does anyone have any other work around? Cheers Tony -- Tony Baylis Spatial Information Specialist Resource and Exploration Mapping Suite 8, 290 Boundary St Spring Hill QLD 4000 Ph 3832 1600 Fax 3832 1603 Mob 0419 759 131 Email [EMAIL PROTECTED] www resexmap.com.au _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
