[AccessD] Select All Text in DropDown

Hollis, Virginia hollisvj at pgdp.usec.com
Thu Sep 28 14:13:02 CDT 2006


I have a form with a combo box that brings up the data for the selected
name in the dropdown. When the user enters, clicks, or has the focus of
the combo I need it to select all the text in the field. For some reason
it always goes to the beginning of the field so they can't just start
typing a name to find it, they always have to scroll the list or
highlight the text in the box first, then delete it or start typing
after it is highlighted. They want the text in the combo from the
current record to already be highlighted so they can easily find another
record by typing the person's name without any extra steps.

 

I tried this, but it only highlights the first 3 characters of the name
instead of the whole name. How does it determine the length of the field
and select all of it?

 

Private Sub FindName_GotFocus()

 

    FindName.SetFocus

    FindName.SelLength = Len(FindName)

 

End Sub

 

Virginia




More information about the AccessD mailing list