Ensuring uniform control width on forms and reports

This utility ensures you have uniform control width on forms and reports. This
example shows the Unit Number as found in many forms and reports through out the
Granite Fleet Manager. Other examples might be part numbers, serial numbers,
license plate numbers or other fields in which you must display all the data and yet
the field might be too short or you unexpectedly had to lengthen the field.

....

This code illustrates going through the collection of forms and reports then going
through the collection of controls on each form or report. If the control matches
certain criteria, being a text, combo or list box then various properties are read
from the control and placed in a table. If a combo box or list box the field name is
extracted from each column of the Row Source query.

[URL="http://msmvps.com/blogs/access/archive/2009/04/06/ensuring-uniform-control-width-on-forms-and-reports.aspx"]http://msmvps.com/blogs/access/archive/2009/04/06/ensuring-uniform-control-width-on-forms-and-reports.aspx[/URL]

[URL="http://www.granite.ab.ca/access/ensuringuniformcontrolwidth.htm"]http://www.granite.ab.ca/access/ensuringuniformcontrolwidth.htm[/URL]

Hi Tony,

I looked briefly at that but see no code. My interest is in a more mundane
use of code that peruses objects of the db. I am currently working on a db
that has had hundreds of hands on it and now has about 700 objects in it.
I would like to identify the dead ends/abandoned objects which I am pretty
sure
account for better than two thirds of the total.

Any assist would be appreciated.

Kevin

"Tony Toews [MVP]" wrote in message

> This utility ensures you have uniform control width on forms and reports.
> This
> example shows the Unit Number as found in many forms and reports through
> out the
> Granite Fleet Manager. Other examples might be part numbers, serial
> numbers,
> license plate numbers or other fields in which you must display all the
> data and yet
> the field might be too short or you unexpectedly had to lengthen the
> field.
>
> ...
>
> This code illustrates going through the collection of forms and reports
> then going
> through the collection of controls on each form or report. If the
> control matches
> certain criteria, being a text, combo or list box then various properties
> are read
> from the control and placed in a table. If a combo box or list box the
> field name is
> extracted from each column of the Row Source query.
>
> [URL="http://msmvps.com/blogs/access/archive/2009/04/06/ensuring-uniform-control-width-on-forms-and-reports.aspx"]http://msmvps.com/blogs/access/archive/2009/04/06/ensuring-uniform-control-width-on-forms-and-reports.aspx[/URL]
>
> [URL="http://www.granite.ab.ca/access/ensuringuniformcontrolwidth.htm"]http://www.granite.ab.ca/access/ensuringuniformcontrolwidth.htm[/URL]
>
>
> --
> Tony Toews, Microsoft Access MVP
> Please respond only in the newsgroups so that others can
> read the entire thread of messages.
> Microsoft Access Links, Hints, Tips & Accounting Systems at
> [URL="http://www.granite.ab.ca/accsmstr.htm"]http://www.granite.ab.ca/accsmstr.htm[/URL]
> Tony's Microsoft Access Blog - [URL="http://msmvps.com/blogs/access/"]http://msmvps.com/blogs/access/[/URL]