On Tue, 20 Apr 2010 17:59:49 -0700 (PDT), Dennis Snelgrove
wrote:

I feel stupid asking this question, but I can't find any previous
posts about it.

Is it possibe to set Access 2007 so that the forms wizard will name
the controls properly? The default is to name the control with the
field name of the data source, but it ignores the proper naming
conventions (or at least what I was taught was the convention). A
textbox should be named "txtFirstName", but instead it just names it
"FirstName", which then requires us to have to go through and manually
rename all the controls.

I suppose that a VBA routine can be written, but after this many
versions of Access it should be at least an option under "Tools,
Options".

This actually brings up a pretty contentious issue. Not everyone uses that
naming convention (or any naming convention at all). Some people I respect a
lot use the same-name default and have no problems with it. I do prefer to
rename controls (txtFirstName, cboEmployeeID, etc.) but generally do it
manually.

I'd be very interested in a wider discussion of the topic!
--

John W. Vinson [MVP]