<div>
Thanks, now at least I can get this database cleaned up.<br />
<br />
Sandra
</div>


Thanks, now at least I can get this database cleaned up.

Sandra

<div>
<div class="content wysiwyg-content">
I have a database that has hundreds(!) of columns in one of the tables. &nbsp;However, I don't think all of them are used. &nbsp;Is there a way I can get a list of all the controls on a form and their column data source so I can weed out the unused columns in the table?<br />
<br />
Sandra
</div>
</div>


I have a database that has hundreds(!) of columns in one of the tables.  However, I don't think all of them are used.  Is there a way I can get a list of all the controls on a form and their column data source so I can weed out the unused columns in the table?

Sandra

List of controls on form and data sources with VBA

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.