Connecting Tech Pros Worldwide Help | Site Map

How to put controls on a form with VBA code

  #1  
Old November 13th, 2005, 02:28 PM
BlueInGreen
Guest
 
Posts: n/a
How can I put a listbox, combobox... on a form, using VBA code?

Thx

  #2  
Old November 13th, 2005, 02:28 PM
polite person
Guest
 
Posts: n/a

re: How to put controls on a form with VBA code


On Wed, 07 Sep 2005 21:39:46 GMT, BlueInGreen <blueingreen@mail.com> wrote:
[color=blue]
>How can I put a listbox, combobox... on a form, using VBA code?
>
>Thx[/color]
Hi
With CreateControl function, which has to be used with the form in design mode.

As these controls have a lot of properties, and design mode is messy to use
at run time it will be lot easier to put the controls you may
need on the form in advance, invisible, and just set their properties and show
them when you want to "create" them.

Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Place Fields In Particular Spot On Form Cindy answers 4 June 27th, 2008 08:26 PM
VBA - Event Driven Programming msquared insights 0 November 26th, 2007 11:44 PM
go to a record in a form kaosyeti@comcast.net via AccessMonster.com answers 6 May 3rd, 2006 03:35 AM
Error looping through controls on form in Access 2003 TD answers 16 November 17th, 2005 05:55 AM