LABELS NOT SHOWING UP

788
2
07-14-2011 03:15 PM
Charles_B_PruynLaw
New Contributor
Ok, so I have a file-geodatabase linked to an access 2007 database (accdb)... the fgdb only contains polygons with three feilds used to link data from other tables.  The accdb has the particulars in it, including an acreage and an owner name, and an ID.  I have joined the accdb to my feature class (in the fgdb) and I can read all of the data from the accdb in the attribute table, and see it all when I use the info tool.  I have labeled the parcels with data from 1 field in the fgdb and two fields from the accdb, and I have verified the expression and it says its a valid label expression, however the two fields from the accdb do not show up in my label.  Why is this happening?  Do I need to go back and use the mdb access format?  I hope not, but I have never had this trouble using the mdb format.  Any help would be GREATLY appreciated!

Also, I have just discovered that it must have soemthing to do with the acreage format.  The ID and the Owners name show up fine in the label, but when I add in the acreage it just drops all of the label values that come from the accdb.  I don't think it worked as text and its not working as a double, is there a limit or restriction on the types of value formats that can be used from an accdb to label?
Tags (2)
0 Kudos
2 Replies
EdgardoMonteros
New Contributor
After connect ArcMap with an .accdb database and add the points like XY event the fields with longitude and Latitude appeared without decimal places. I could change the format in the table properties defining again the decimal places. After that, I could see the complete numbers of the coordinates. I exported this event tables like shape file, and the coordinates appeared again without decimal places. I tried to modify the format but was not succesfull. Any ideas?
Regards

Edgardo Monteros
0 Kudos
BillLotz
Occasional Contributor II
Ok, so I have a file-geodatabase linked to an access 2007 database (accdb)... the fgdb only contains polygons with three feilds used to link data from other tables. The accdb has the particulars in it, including an acreage and an owner name, and an ID. I have joined the accdb to my feature class (in the fgdb) and I can read all of the data from the accdb in the attribute table, and see it all when I use the info tool. I have labeled the parcels with data from 1 field in the fgdb and two fields from the accdb, and I have verified the expression and it says its a valid label expression, however the two fields from the accdb do not show up in my label. Why is this happening? Do I need to go back and use the mdb access format? I hope not, but I have never had this trouble using the mdb format. Any help would be GREATLY appreciated!

Also, I have just discovered that it must have soemthing to do with the acreage format. The ID and the Owners name show up fine in the label, but when I add in the acreage it just drops all of the label values that come from the accdb. I don't think it worked as text and its not working as a double, is there a limit or restriction on the types of value formats that can be used from an accdb to label?

I am having a similar label failure using the vb 'Split' expression on a joined field. When I export the joined data and bring it back in as a shapefile, I can label with no problems.
0 Kudos