Results 1 to 4 of 4
  1. #1
    masoud_sedighy is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Dec 2011
    Posts
    78

    listbox column head format backcolor

    I need to set the entire column head in the list box to bold and color. So I created a list box, and in the list box property under column heads I selected yes, how can I make this list box bold without effect the rest of the data in the list.

    Best Regards.

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    You can't.
    What I do is leave column heads = No, then create labels and place them above the list box. You can format the labels any way you want.

  3. #3
    masoud_sedighy is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Dec 2011
    Posts
    78
    my problem is , my listbox has 2 rowsource depending what i select on treeview node in the form rowsource of list box changes so column heads also change. if i put lable controls, these are constant and i can use just for one row source.
    how i can solve this problem,please?

  4. #4
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Have two sets of labels. Lets say one label is "Items" and the other label is "Tasks".
    In the code where you change the list box row source, also set the visible property of the labels.

    If you select the node that sets the list box row source to Items, then set the label for "Items" to visible and set the label for "Tasks" to hidden (visible = false)

    If you select the node that sets the list box row source to Tasks, then set the label for "Tasks" to visible and set the label for "Items" to hidden (visible = false)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. searching 2nd column in multi-column listbox?
    By RedGoneWILD in forum Programming
    Replies: 6
    Last Post: 07-07-2012, 09:21 PM
  2. Get column head name from list box?
    By joelmeaders in forum Programming
    Replies: 3
    Last Post: 01-31-2012, 11:23 AM
  3. Replies: 1
    Last Post: 12-08-2011, 08:03 AM
  4. checkbox format for listbox
    By cpet in forum Access
    Replies: 3
    Last Post: 09-20-2010, 08:02 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums