DataObject object reference for MS Access

Question

What reference library should I use to define DataObject in VBA code for MS Access project?

Answer 1

Hi @Doug

To use the DataObject type in an MS Access VBA project, you need to reference the Microsoft Forms 2.0 Object Library, because DataObject is not part of native VBA and is instead provided by the MSForms library. Without this reference, you’ll get “User-defined type not defined” when declaring an object.

To do this Go to Tools > References > Browse then navigate to locations such as C:\Windows\System32, C:\Windows\SysWOW64, and look for a file named FM20.DLL then open it.

I hope this information helps.

---

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Use the Microsoft Forms 2.0 Object Library reference.

In an Access VBA project, add it like any other reference:

1. Open any module.
2. Go to Tools → References….
3. Check Microsoft Forms 2.0 Object Library.
4. Click OK.

After that, DataObject is available (from Microsoft.Vbe.Interop.Forms) and can be used in code.

---

References:

• DataObject Interface
• What is the difference between the DataObject and the Clipboard?
• Using ADO with Microsoft Visual Basic
• Access desktop database reference