textbox with same name in visual basic for excel

A control and a section on the same form can't share the same name.

You can't use 'Form' or 'Report' to name a control or section.Ĭontrols on the same form, report, or data access page can't have the same name, but controls on different forms, reports, or data access pages can have the same name. If you create a control by dragging a field from the field list, the field's FieldName property setting is copied to the control's Name property box. For example, if the first control that you add to a form is a text box, its Name property setting is Text1.įor a bound control, the default name is the name of the field in the underlying source of data. A form can't have the same name as another system object, such as the Screen object.įor an unbound control, the default name is the type of control plus a unique integer.

For example, the first new form is Form1, the second new form is Form2, and so on. The default name for new objects is the object name plus a unique integer. For controls, the name may be as long as 255 characters. For Access objects, the name may be up to 64 characters long. RemarksĪ valid name must conform to the standard naming conventions for Microsoft Access. SyntaxĮxpression A variable that represents a TextBox object. Use the Name property to specify or determine the string expression that identifies the name of an object.

Textbox with same name in visual basic for excel