Using the columnhidden property in on a List Box

[Access_Novice]

I have a list box with four columns: parentID, firstName, lastName and fullName. I am trying to hide the 2nd column (firstName). Right now, the List box is the only control on my form.




I wasn't sure how to get this property to work just by returning to datasheet view, so for now, I put the code under the OnClick event:

Private Sub listBoxParent_Click()
Me.listBoxParent.[firstName].ColumnHidden = True
End Sub


The name of the list box is listBoxParent.

1. Why isn't this working?
2. Do I have to put this code under an event? Is there another way to automatically make the 2nd column hidden when I exit design view and enter datasheet view?

[pbaldy]

I'm not clear on the layout, but typically the columns in a listbox are controlled by its column widths property.

[Missinglinq]

And that has to be set in Design View, if I remember correctly. Why would you want to hide a Column of a Listbox when clicking on the Listbox?

[Access_Novice]

And that has to be set in Design View, if I remember correctly. Why would you want to hide a Column of a Listbox when clicking on the Listbox?

The reason being that I may not want to display all of the fields that come over from the Row Source.

[pbaldy]

Typically you hide them in design view with the column widths property.

[Access_Novice]

Typically you hide them in design view with the column widths property.

Yes, I know how to do that. I was on the Microsoft website lookin a properties of the List Box and one was 'columnhidden' so I was just curious to see how that was used.

[June7]

One of the more confusing MS helps I've run into.

ColumnHidden is also indicated as a textbox property. However, what really appears to be happening is a field/control is hidden when form is in Datasheet view, otherwise not relevant and code is ignored.

http://office.microsoft.com/en-in/ac...080203741.aspx
http://office.microsoft.com/en-in/ac...080203741.aspx

[Access_Novice]

One of the more confusing MS helps I've run into.

ColumnHidden is also indicated as a textbox property. However, what really appears to be happening is a field/control is hidden when form is in Datasheet view, otherwise not relevant and code is ignored.

http://office.microsoft.com/en-in/ac...080203741.aspx
http://office.microsoft.com/en-in/ac...080203741.aspx

I saw those sites. That is where I got the idea to try:

Private Sub listBoxParent_Click()
Me.listBoxParent.[firstName].ColumnHidden = True
End Sub

But I still can't get this to work. I am using 'Me' since I am in the form that contains the List Box, then I state the name of the list box. My attempt to specify which column I want to hide (firstName) is not working so I don't know what I am doing wrong.

Any ideas?

[June7]

Read my previous post again. Note: "field/control is hidden when form is in Datasheet view"

I just tested this and it does hide field/control. It does NOT hide a column of a combobox or listbox.

[Access_Novice]

Read my previous post again. Note: "field/control is hidden when form is in Datasheet view"

I just tested this and it does hide field/control. It does NOT hide a column of a combobox or listbox.

I tried this again. I didn't see the field/control hidden when switched into Datasheet view so I don't know what I'm doing wrong. Also, I don't know why it would hide a field/control if the property name is columnHidden.

[June7]

I created a form called Airports and opened in Datasheet view. I ran this one line in the Immediate window:

Forms!Airports!FAAID.ColumnHidden = True

Zap! The column disappears from view.

Forms!Airports!FAAID.ColumnHidden = False

Zap! The column reappears.

[Access_Novice]

I created a form called Airports and opened in Datasheet view. I ran this one line in the Immediate window:

Forms!Airports!FAAID.ColumnHidden = True

Zap! The column disappears from view.

Forms!Airports!FAAID.ColumnHidden = False

Zap! The column reappears.

Ok. What is FAAID? Is it the name of the List Box, the column to be hidden, a text box?

[June7]

FAAID is name of field and also name of textbox/listbox/combobox (doesn't matter which control is used).

If control has name different than the field, use name of control.

[ItsMe]

Ok. What is FAAID? Is it the name of the List Box, the column to be hidden, a text box?

I don't see how the property "Column Hidden" is relevant to your List Box. As June7 pointed out, this property is for DS view of your form. As others have pointed out, your listbox has its own properties and if you want to hide a column within the listbox you will need to use the widths property of the list box control. The value of zero will hide that column within the listbox, respectively.

Typicaly, this property is edited in design view. If you want it to be dynamicaly updated, you need to have a specific event fire some VBA code. I use code similar to the following to dynamicaly adjust the widths property for combos and list boxes.

Dim strQuote As String
strQuote = """"
Dim strWidths As String
strWidths = "0" & strQuote & "; " & "0.6" & strQuote & "; " & "0.7" & strQuote & "; " & "0" & strQuote
Me.cmbCont.ColumnWidths = strWidths

This example hides the first column. Its value is zero. I do not want it displayed to the user because it contains a primary key value. It also hides the last column, the fourth column.

.