I've tried to create my own activex control in vb6 to accomplish something in access. I posted a similar thing to the access forum with little response- maybe the solution lies on th vb side. My question relates to what is the best way to get access (or any other host, I presume) to see the data in textboxes that are on the custom activex control.
   Some possibilities are assigning the textbox value to a property of the activex control and retrieving it in access by referencing the property or creating a function in the activex control that can be called from access and returns the value of the desired textbox.
   Ideally, I need access to recognize that the activex control has textboxes on it so I can reference them directly. i.e. Forms!Form1!MyActivex.Controls.Count gives me 0, but it should be 82.

Moderator, please remove this post- its in the wrong place!