Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Location
    Guelph, Canada
    Posts
    39

    Unanswered: Combo dropdown arrow

    In Datasheet view my combo boxes don't disply the dropdown arrows and
    consequently they aren't an eyesore.

    Right now my Form view which has combo boxes is displaying dozens and
    dozens of dropdown arrows. How can I turn off this display so that it
    looks the same as in Datasheet view?
    That is, only when a combo box is selected, its dropdown arrow is
    displayed?

    I certainly hope that at the very least, I can control this using VB code.

    Trying to spiff up my forms and move away from Datasheet view.

    Thanks very much for your help! Eric

  2. #2
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    If the controls (fields) are actual comboboxes then you are stuck but here is a great way to use dropdowns

    1)Avoid lookups (dropdowns) at the table level
    2)On a form create your field and using a drop down to fill that field - size the combobox on screen so just the arrow is visible
    3)place the down arrow adjacent to the text field to the right
    4)after the selecting the data from the combo - have the data populate your field
    Now - to eliminate all the arrows set to them to visible = false
    On set focus of the field you want to update turn the appropriate dropdowns visible proerty to true

    On Lostfocus of that field set the dropdown's visible propert to false

    HTH

  3. #3
    Join Date
    Jan 2003
    Location
    Guelph, Canada
    Posts
    39
    That's a great idea AXS!
    I tried it out but I have a couple of problems.

    Firstly, I'm using a continuous form and when the dropdown arrow is activated (OnFocus) I get 20+ dropdowns coming at me on the screen!

    Secondly when I leave the text field to go to the dropdown to make my selection, the dropdown disappears (as programmed by LostFocus).

    Thanks for your help! Eric

  4. #4
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    Ah! Continuous forms - therein is the problem - to actually run a good deal of code based on the controls properties you will have to utilize the on current event as well of the form. But making all the down arrows not visible from within the continuous form can only be accomplished with some smoke and mirrors in VB

    Try this:


    dblclick the two textboxes within the form and store (pass) those values in two hidden textboxes on the header of the form after the dblclick of the second field and passing that value to the hidden(not visible) control launch the form that looks at the hidden controls for its criteria.

    HTH
    Axsprog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •