[AccessD] Iterate through controls on a form

Heenan, Lambert Lambert.Heenan at AIG.com
Fri Aug 26 10:19:34 CDT 2005


Basically it's ...

Dim c as control
	For Each c in Me
		Debug.Print c.Name, c.ControlSource
	Next c

But you'll have to check for controls that do not have a Controlsource
property.


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Friday, August 26, 2005 11:00 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Iterate through controls on a form


Anyone got a loop handy that iterates through the controls on a form and
prints their data source? Ideally, it would also print a vbCRLF between the
controls on each tab page, if there are multiple pages. TIA, Arthur

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



More information about the AccessD mailing list