Susan Harkins
ssharkins at bellsouth.net
Thu Feb 17 14:12:11 CST 2005
Yeah, the Help doesn't really give too much information, but my guess is that the AccessObjectProperties aren't the same as the form properties. I need to get at the form's properties for ALL the forms, not just the open ones, so I need to use the AccessObject. Susan H. Hi Susan Perhaps simply no AccessObjectProperty is present ..? /gustav >>> ssharkins at bellsouth.net 17-02-2005 20:43:45 >>> The following procedure seems to totally skip the second For Each loop. No error, it just skips it, as if there are no properties in the Properties collection, which may be the case. I realize we're dealing with different collections and I may not be referencing things right. Any help? Thanks! Susan H. Public Function EnumAllFormProp() 'Print the name and setting for 'each property in every form. Dim obj As Access.AccessObject Dim prp As Access.AccessObjectProperty For Each obj In CurrentProject.AllForms Debug.Print obj.Name For Each prp In obj.Properties Debug.Print prp.Name Debug.Print prp.Value Next Next End Function -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com