[AccessD] show last value in listbox

Gustav Brock Gustav at cactus.dk
Thu Jul 21 12:41:57 CDT 2005


Hi Pedro

Your listbox may not have settled at the OnCurrent event of the form.

Thus, create a textbox and set the controlsource to:

  =SetListboxLast()

and create this function in the code module of the form:

Private Function SetListboxLast()

  ' Set listbox lstDemo to the last entry.

  With Me!lstDemo
    If IsNull(.Value) Then
      .Value = .ItemData(.ListCount - 1)
    End If
  End With
  
End Function

Then, shortly after the form has opened, the listbox is set to its last
value.
This is for a single-select listbox.

/gustav


>>> pedro at plex.nl 07/21 4:00 pm >>>
Hello Group,

is it possible, when opening a listbox with a long list of values, it
opens always with the first value. Is it possible to open with the last
values.

Pedro Janssen




More information about the AccessD mailing list