G
Guest
Hello Crystal,
some time ago you were kind enough to assist me with an issue on the Access
Discussion Group. You indicated that you may have some code capable of
replicating the functionality of a ListBox on a form, i.e. using a continuous
form instead of the ListBox.
If that is still the case, could you please let me know where I could
retrieve the sample from?
(One limitation I would like to overcome for instance is the inability for a
ListBox to display and update check boxes and respond to conditional
formatting. The continuous form would come in very handy for that.)
I also wonder if in such a continuous subform it would be possible to
implement the selection of discontinuous records, like in a ListBox (pressing
Ctr and clicking on the record).
Thank you very much.
Gino
Below please find part of the thread I am referring to. (7/22/2006 9:14 AM
PST)
Hi Gino,
As Larry said, exactly what you want to do cannot be done within Access
requirements, but there are other ways to get the same functionality:
1.instead of using a listbox, consider using a continuous form
(I have some really neat code to highlight the active record if you want it)
2.if you want to keep using the listbox, the only way to trap the
movements is to control them... lock the listbox and force the users to
scroll using command buttons for (ie UP, DOWN, TOP, BOTTOM, and
possibly also a Search combo...
Warm Regards,
Crystal
some time ago you were kind enough to assist me with an issue on the Access
Discussion Group. You indicated that you may have some code capable of
replicating the functionality of a ListBox on a form, i.e. using a continuous
form instead of the ListBox.
If that is still the case, could you please let me know where I could
retrieve the sample from?
(One limitation I would like to overcome for instance is the inability for a
ListBox to display and update check boxes and respond to conditional
formatting. The continuous form would come in very handy for that.)
I also wonder if in such a continuous subform it would be possible to
implement the selection of discontinuous records, like in a ListBox (pressing
Ctr and clicking on the record).
Thank you very much.
Gino
Below please find part of the thread I am referring to. (7/22/2006 9:14 AM
PST)
Hi Gino,
As Larry said, exactly what you want to do cannot be done within Access
requirements, but there are other ways to get the same functionality:
1.instead of using a listbox, consider using a continuous form
(I have some really neat code to highlight the active record if you want it)
2.if you want to keep using the listbox, the only way to trap the
movements is to control them... lock the listbox and force the users to
scroll using command buttons for (ie UP, DOWN, TOP, BOTTOM, and
possibly also a Search combo...
Warm Regards,
Crystal