Discussion:
Binding Collection Error
(too old to reply)
Chris Kowitz
2004-01-20 17:07:05 UTC
Permalink
I have a combo box bound to a data source and I keep getting the 'Binding
Collection Error' - 'Field Not Updatable, Bound Property Name: Text, Field
Name: strState' I cannot find any explaination of the error anywhere and
everything looks like it's setup correctly. I don't get this error message
on any of the other bound fields. What does this error mean and why am I
getting it?

Enviornment:: W2kPro SP4, VB6 (SP5), ADO 2.7

Thanks.
Ken Halter
2004-01-20 17:47:13 UTC
Permalink
Sounds like you have a combobox set to style 2 (dropdown list). If that's the case, the
Text property is read only.
--
Ken Halter - MS-MVP-VB - http://www.vbsight.com
Please keep it in the groups..
Post by Chris Kowitz
I have a combo box bound to a data source and I keep getting the
'Binding Collection Error' - 'Field Not Updatable, Bound Property
Name: Text, Field Name: strState' I cannot find any explaination
of the error anywhere and everything looks like it's setup correctly.
I don't get this error message on any of the other bound fields.
What does this error mean and why am I getting it?
Enviornment:: W2kPro SP4, VB6 (SP5), ADO 2.7
Thanks.
Peter Huang
2004-01-21 07:03:48 UTC
Permalink
Hi Chris,

Thanks for using Microsoft MSDN Managed Newsgroup. My name is Peter, and I
will be assisting you on this issue.

First of all, I would like to confirm my understanding of your issue.
From your description, I understand that you wants to bind a combo box to a
datasource, and you encounter error:
'Binding
Collection Error' - 'Field Not Updatable, Bound Property Name: Text, Field
Name: strState'
Have I fully understood you? If there is anything I misunderstood, please
feel free to let me know.

AS Ken said, did you set the combobox to style 2 (dropdown list)?
If so , I think this is by design, for a workaround , you may try to use
DataCombo, you may use it by add the Microsoft DataList Controls 6.0.
Here is a KB article, you may take a look.
189682 HOWTO: Bind a DataList or DataCombo to a Recordset at Run Time
http://support.microsoft.com/?id=189682

If you have any concern on this issue, please post here.

Best regards,
Peter Huang
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
Andy Guevara
2004-01-22 01:16:45 UTC
Permalink
Hi,

I've got a similar problem and I've been a couple of days researching
on the web. My VB code is simpler, I have bound text controls which
work fine in debug mode, but fail with the "binding collection error"
in compiled mode. This only happens on Win 2K with SP4. SP3 didn't
have this problem.

I've seen lots of calls for help, but nothing short of unbinding the
controls seems to work.

Thanks in advance,

Andy Guevara

Loading...