Form wizard question

[Jon123]

Working on a form and when using the wizard to add a command button or a txt box the wizard gives it a funny name like command989. Im wondering why? Where does this default come from and why is the number so high? There is no way anywhere near that number of command buttons on this form. Does this matter? Can it be reset?

Jon

 

[WayneRyan]

Jon,

When Access names/numbers your objects for you it generally gives you something like Text0, Text1, Command0, Command1.

There is no problem with changing the name after it has assigned it.
The one thing to look for is, if it generates code, you will find some
code like:

Private Sub Command989_Click()
...
End Sub

Just change the "Command989" to your new name and you'll be OK.

Wayne

 

[CJ_London]

The number is incremented across all controls so if you create a textbox and label it will be text1 and label2.

As Wayne says, you can change it to something more meaningful (it is advisable to do so) and rename the code event if one already exists

 

[Jon123]

Can you change access 2010 so that when you use the wizard to create a command button it uses vba code as did 2007 instead of using macros?

 

[CJ_London]

I don't think so, I don't use the wizards, and looking at this link I think I am right

http://social.msdn.microsoft.com/Fo...2663f2a8a/access-2010-wizards?forum=accessdev

However there is an option on the form design ribbon to convert macro's to vba code.

One suggestion in the above link is to develop as a .mdb rather than .accdb which apparently solves the problem.