Professional Web Applications Themes

Help with ListBox Object . . . Please - Microsoft Access

Greetings, I am wondering if there is a way to change the color of a "ListBox" item based on the bound column matching and entry in a subfrom below. Let me explain: 1. I have a ListBox at the top of a form that contains a PartNumber and Description Field and is based on a list of parts. 2. The user selects the PartNumber to add and it populates a subform of parts below. 3. In this application the user may want to add that part again but assign it to a different Bin location. 4. I would like to ...

  1. #1

    Default Help with ListBox Object . . . Please

    Greetings,

    I am wondering if there is a way to change the color of a "ListBox" item
    based on the bound column matching and entry in a subfrom below. Let me
    explain:

    1. I have a ListBox at the top of a form that contains a PartNumber and
    Description Field and is based on a list of parts.

    2. The user selects the PartNumber to add and it populates a subform of
    parts below.

    3. In this application the user may want to add that part again but assign
    it to a different Bin location.

    4. I would like to change the text color of any part in the Listbox that
    has a matching PartNumber in the subform below.

    Thanks in advance for any help on this.

    Regards,

    Keith


    Twig Guest

  2. #2

    Default Re: Help with ListBox Object . . . Please

    Any help available on this one. My head is sore from beating it on the
    wall! :)

    Thanks,

    Keith


    "Twig" <junkcomcast.net> wrote in message
    news:ehtbhsuRDHA.2676TK2MSFTNGP10.phx.gbl...
    > Greetings,
    >
    > I am wondering if there is a way to change the color of a "ListBox" item
    > based on the bound column matching and entry in a subfrom below. Let me
    > explain:
    >
    > 1. I have a ListBox at the top of a form that contains a PartNumber and
    > Description Field and is based on a list of parts.
    >
    > 2. The user selects the PartNumber to add and it populates a subform of
    > parts below.
    >
    > 3. In this application the user may want to add that part again but
    assign
    > it to a different Bin location.
    >
    > 4. I would like to change the text color of any part in the Listbox that
    > has a matching PartNumber in the subform below.
    >
    > Thanks in advance for any help on this.
    >
    > Regards,
    >
    > Keith
    >
    >

    Twig Guest

  3. #3

    Default Re: Help with ListBox Object . . . Please

    On Thu, 10 Jul 2003 14:10:44 -0400, "Twig" <junkcomcast.net> wrote:
    >Any help available on this one. My head is sore from beating it on the
    >wall! :)
    An Access ListBox control does not include the capability that you
    desire. Quit beating yourself up - you just can't do it using a
    Listbox.

    If it's just for data display, consider using a Subform with
    conditional formatting.

    John W. Vinson[MVP]
    Come for live chats every Tuesday and Thursday
    [url]http://go.compuserve.com/msdevapps?loc=us&access=public[/url]
    John Vinson Guest

  4. #4

    Default Re: Help with ListBox Object . . . Please

    Thanks for the help.... I used a subform and it actually work out quite
    well.

    Regards,

    Keith


    "John Vinson" <jvinsonSTOP_SPAM.WysardOfInfo.com> wrote in message
    news:moergv47q4bbuml55splspqicihigl4qlo4ax.com...
    > On Thu, 10 Jul 2003 14:10:44 -0400, "Twig" <junkcomcast.net> wrote:
    >
    > >Any help available on this one. My head is sore from beating it on the
    > >wall! :)
    >
    > An Access ListBox control does not include the capability that you
    > desire. Quit beating yourself up - you just can't do it using a
    > Listbox.
    >
    > If it's just for data display, consider using a Subform with
    > conditional formatting.
    >
    > John W. Vinson[MVP]
    > Come for live chats every Tuesday and Thursday
    > [url]http://go.compuserve.com/msdevapps?loc=us&access=public[/url]

    Twig Guest

Similar Threads

  1. listbox to populate a listbox
    By truballer in forum Macromedia Flash Data Integration
    Replies: 0
    Last Post: March 16th, 08:48 PM
  2. click listbox and refresh another listbox
    By DC Gringo in forum ASP.NET Building Controls
    Replies: 0
    Last Post: April 6th, 02:13 AM
  3. Item label displays as "," when moving from listbox to listbox
    By quadrant6 webforumsuser@macromedia.com in forum Macromedia Flash Actionscript
    Replies: 1
    Last Post: January 27th, 02:45 AM
  4. Binding custom object to a listbox
    By Fraggle in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: November 4th, 02:32 PM
  5. Replies: 0
    Last Post: August 3rd, 10:18 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139