Re: List box, multiselect

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Ron Weiner (weinNoSpam1_at_mindspring.com)
Date: 09/22/04 

Date: Wed, 22 Sep 2004 06:51:25 -0400

You CAN set this property programmatically with VBA BUT you have to open the
form in Design Mode to do it.

DoCmd.OpenForm "xxx" ,acDesign

Ron W

"TRM" <anonymous@discussions.microsoft.com> wrote in message
news:45b801c4a07b$ea4ca690$a301280a@phx.gbl...
> Thanks. I thought I saw in the help file that it could
> be set in VB. Must have been something else. THANKS!
> >-----Original Message-----
> >Sorry you cant do that. Access help clearly says that
> the MultiSelect
> >property can only be changed in Form Design.
> >
> >You might want to consider having 2 listboxes on
> MultiSelect and the other
> >not both with the same RowSource, and flip their
> visibility as desired.
> >While this might be a little messy, it is doable.
> >
> >Ron W
> >"TRM" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:2bd901c49fb4$0c539370$a501280a@phx.gbl...
> >> I would like to programatically change a listbox
> >> from "multiselect" to "standard" depending on how/what
> >> the circumstances are. I'm getting an error that the
> >> property cannot be updated (something similar).
> >>
> >> Any ideas?
> >>
> >> THANKS!
> >
> >
> >.
> >

Relevant Pages

  • Re: verify copy
    ... Sorry Ron, ... then consider buying Roxio or ... > That's surely in the Help file or documentation for Roxio, ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: modify size of calendar control
    ... "Ron de Bruin" wrote in message ... > When in Design Mode I see the Full month Calendar, ... > Private Sub Worksheet_SelectionChange ...
    (microsoft.public.excel.programming)
  • Re: Another Time Calulation Question - Sorry.
    ... Thanks Ron, The minutes are calculating a treat:) The hours though ... I don't mind being wrong, I'd just like you to prove it! ... Microsoft MVP (Excel) ... show in columns I and J. Honest, I've used the help file and looked about ...
    (microsoft.public.excel.newusers)
  • Re: Formatting Microsoft Graph 97 Chart
    ... If you open a graph object in design mode, to the point where you have the ... if I remember correctly in that help file. ... "Ian Belcher" wrote in message ...
    (microsoft.public.access.reports)
  • alternatives to streamsec ?
    ... I'm after an encryption library that's easy to use, has a help file, ... and perhaps some basic examples e.g. encrypting/decrypting data ... from a TmemoryStream. ... thanks, Ron ...
    (borland.public.delphi.thirdpartytools.general)