CODEWITHSUNDEEP
ms-accessvba
Quint
Quint

Reputation: 590

Access: ListBox.Column Property Object required

According to Here .Column(1, 0) Should work for Access Form ListBoxes but I am getting an objext required error for .Column(1, 0) = "Name" Here is the full line of code.

With Me.ListBox_Status
.AddItem ("User")
.AddItem "VICI Launcher" '4
.AddItem (Command_Mx.Caption) '0
.AddItem (Command_Fm.Caption) '1
.AddItem (Command_Anal.Caption) '2
.AddItem "DB Backup" '5
.Column(1, 0) = "Name'"
'Call UserIn
WasteTime (1)
End With

Upvotes: 1

Views: 687

Answers (1)

Andre
Andre

Reputation: 27634

You can use the Column property to refer to a specific column, or column and row combination, in a multiple-column combo box or list box.
Read-only Variant.

The problem is that the .Column() property is read-only. You can't use it to set a "cell" in the listbox.
It is only used to read values from it.

But the error message is quite strange and misleading. I can't really imagine what Access is trying to do here.

Upvotes: 1

Related Questions