ACC2000: Buddy Properties for UpDown Control Do Not Work in Microsoft Access (284140)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q284140
Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

For a Microsoft Access 97 version of this article, see 161402.

SYMPTOMS

When you use the Microsoft UpDown control, version 6.0, in Microsoft Access 2000, you cannot use any of the Buddy properties of the control. Depending on what you are trying to do, you may receive one or more of the following error messages:
BuddyControl must be a separate control within the same container.
BuddyControl property must be set first.
Invalid property value.

CAUSE

The Buddy properties of the UpDown control are not supported by Microsoft Access 2000. The Buddy properties contain specific functionality that is supported in Microsoft Visual Basic.

RESOLUTION

Do not use any of the Buddy properties of the UpDown control in Microsoft Access 2000.

MORE INFORMATION

The Microsoft UpDown control, version 6.0, is included with Microsoft Office 2000 Developer as a replacement for the Spin Button control from earlier versions.

You can use the UpDown control in Microsoft Access 2000 with the exception of the following Buddy properties:

BuddyControl
SyncBuddy
AutoBuddy
BuddyProperty

In Microsoft Visual Basic 6.0, when you place the UpDown control on a form, you can set the BuddyControl property to a text box that contains a numeric value. Then, without writing any code, you are able to run the form and click the UpDown control to increment or decrement the numeric value in the text box. This feature does not work in Microsoft Access 2000.

Steps to Reproduce the Behavior


  1. Open the sample database Northwind.mdb.
  2. Create a new form that is not based on any table or query in Design view.
  3. On the Insert menu, click ActiveX Control.
  4. In the Insert ActiveX Control dialog box, click Microsoft UpDown Control, version 6.0, and then click OK.
  5. Add a text box control to the form, and then set its Name property to Text0.
  6. Double-click the UpDown control to open the UpDown Properties dialog box.
  7. Click the Buddy tab, and then type Text0 in the BuddyControl box. Note that as soon as you click Apply, you receive the following error message:
    BuddyControl must be a separate control within the same container.
Modification Type:MinorLast Reviewed:7/14/2004
Keywords:kberrmsg kbprb KB284140
©2004 Microsoft Corporation. All rights reserved.