T
Tony Toews [MVP]
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.
http://msmvps.com/blogs/access/arch...iform-control-width-on-forms-and-reports.aspx
http://www.granite.ab.ca/access/ensuringuniformcontrolwidth.htm
--
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
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
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.
http://msmvps.com/blogs/access/arch...iform-control-width-on-forms-and-reports.aspx
http://www.granite.ab.ca/access/ensuringuniformcontrolwidth.htm
--
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
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/