Drop Down List Position on Form

[PPCO]

When a list drops down on a form from a list/combo box, is it possible to
position where the list drops down at (want to perhaps get it to drop down in
front of the field instead of to the right of it). Thanks

 

[Antonette]

PPCO;

You have a few options here. You can write a little VBA script
triggered by the Event to Me.(NameofBox).Visible = False on one box and then
when it hits another box do Me.(NameofBox).Visible = True.

You can also just move the box over the other fields and use the
View Option, go to Tab Order and move the box to where you want it in the
sequence.

There is a third way of using Overlap, but it takes some digging to
find how to use this function.


Good Luck

Toni

 

[PPCO]

Hmm, don't think I explained myself very well. What's happening is when the
list drops down, it goes to the right of the field (I think because I have it
displaying quite a few lines in the list, it's trying to use as much of the
screen as possible). I just want it to drop down in front of the field, not
to the right of it.