John W. Vinson wrote in
news
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 use the default name until the point that:

1. the control is referenced in VBA code, OR

2. the code gets one of its own events defined in VBA code.

In other words, I don't rename until the point at which it's needed.

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

I find it very annoying that the Fields collection on forms has been
made almost useless by Access's inability to properly resolve
references to members of that collection if they are not duplicated
in a control's ControlSource. That started to be a problem in A2000
and has gotten worse since.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/