[AccessD] Odd property error

How about SetFieldDescription =  Nz( fld.Properties("Description"))?

Rocky





 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Sunday, November 25, 2007 5:29 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Odd property error

I'm using the following statement to retrieve the description properties for
query fields:

SetFieldDescription = fld.Properties("Description")

As long as there's a description, it works fine. An empty property returns
the error "property not found"

I've tried a Resume Next error statement, but VBA acts like it isn't even
there and still returns the error.

I've tried numerous ways to avoid or capture it, and nothing's worked.

As far as I know, Description isn't user-defined and I think VBA's just
returning one of its many, famous erroneous error messages that aren't so
terribly helpful. However, you'd think Resume Next would ignore it, but it
doesn't seem to.

Anyone seen anything like this before?

I haven't tried a real error handling routine because I'd hoped to avoid
doing so if there was an easier solution.

Susan H. 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.503 / Virus Database: 269.16.6/1150 - Release Date: 11/24/2007
5:58 PM