ComboBox.RowSource Property: error '2176' The setting for this pro

D

Darizotas

Hello Everybody,

I have a question about this property. I am setting the value of this
property with the name of all the tables contained in the TableDef
Collection. That is, a list value is created:
......
Dim fields As String: fields = ""
Dim tables As Collection
Set tables = DAOUtils.ListTables(TSourceDb)
fields = MiscUtils.CreateListFields(tables)
Set tables = Nothing
......
CCSourceTable.RowSourceType = "Value List"
CCSourceTable.RowSource = fields
.....
It seems to be such a big number of tables, at least 178 items and it raises
the error 2176. But I have other ComboBoxes that are using queries with a lot
of elements (more than 178) and no error raises.

Could anybody tell me why??

Thanks in advance,

Dario.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error 2176 - Setting for Property too long 1
LinkMasterFields property setting 13
using multiple fields from a table 3
ItemAdd and FolderAdd events problem with Public Folders 0
Access 2007 Property for visible tables in navigation pane? 2
enumerating tables collection or fields in ADOX blows up Access 4
VBA works in orignal but fails in copy of database 1
Run-time error '2176' The setting for this property is too long. 0

Top