I use Format$(FIELD, "#")
where FIELD is your label. I asked the same question in April of 2004 and got several answers, but Tim Nuteson's worked best for me. http://lists.directionsmag.com/discussion/read.php?f=7&t=39595&a=2 Troy GIS Tech Rural Metro Fire/Southwest Ambulance - for 2 more days Tony Baylis <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/17/2006 08:34 PM Please respond to [EMAIL PROTECTED] To Mapinfo-L <[email protected]> cc 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 ----------------------------------------- This communication may contain confidential and/or proprietary information and may not be disclosed to anyone other than the intended addressee. Any other disclosure is strictly prohibited by law. If you are not the intended addressee, you have received this communication in error. Please notify the sender immediately and destroy the communication including all content and any attachments. Thank you. _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
