A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Automatic control names



 
 
Thread Tools Display Modes
  #1  
Old April 21st, 2010, 01:59 AM posted to microsoft.public.access.forms
Dennis Snelgrove
external usenet poster
 
Posts: 8
Default Automatic control names

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".
  #2  
Old April 21st, 2010, 02:58 AM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Automatic control names

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]
  #3  
Old April 21st, 2010, 04:10 AM posted to microsoft.public.access.forms
Dennis Snelgrove
external usenet poster
 
Posts: 8
Default Automatic control names

On Apr 20, 9:58*pm, John W. Vinson
wrote:
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!


I know that some people use different conventions. I use qry for a
Select query, aqry, uqry, dqry, etc. as is appropriate. frm and sfrm,
chk for checkbox, cbo for combobox. And on it goes. My point is that
if Microsoft made it a checkbox option in the Options menu, they could
adopt any given naming convention that makes sense. If it's an option,
the user can leave it unchosen and get the current set-up. Speaking
for myself, I don't mind adopting to a slightly different convention
if it's a logical one. Or if they wanted to get technical, set up a
table in the Options menu where the user can enter the desired
prefixes for any/all controls (by type) and as the wizard makes the
form, it can prepend (is that a word?) the prefix, if there is one.

I also would be interested in a discussion...
  #4  
Old April 21st, 2010, 12:37 PM posted to microsoft.public.access.forms
BruceM via AccessMonster.com
external usenet poster
 
Posts: 448
Default Automatic control names

That's what I would want: a way to specify a naming convention. I too use
prefix plus field name, and would like to automate the control names.

BTW, as I understand "prepend" is used sometimes in computer jargon, but its
invention seems to have been based on a misunderstanding of "append", which
by definition is an addition, but not necessarily at the end.

Dennis Snelgrove wrote:
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

[quoted text clipped - 3 lines]

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


I know that some people use different conventions. I use qry for a
Select query, aqry, uqry, dqry, etc. as is appropriate. frm and sfrm,
chk for checkbox, cbo for combobox. And on it goes. My point is that
if Microsoft made it a checkbox option in the Options menu, they could
adopt any given naming convention that makes sense. If it's an option,
the user can leave it unchosen and get the current set-up. Speaking
for myself, I don't mind adopting to a slightly different convention
if it's a logical one. Or if they wanted to get technical, set up a
table in the Options menu where the user can enter the desired
prefixes for any/all controls (by type) and as the wizard makes the
form, it can prepend (is that a word?) the prefix, if there is one.

I also would be interested in a discussion...


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201004/1

  #5  
Old April 21st, 2010, 07:36 PM posted to microsoft.public.access.forms
David W. Fenton
external usenet poster
 
Posts: 3,373
Default Automatic control names

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/
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:18 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.