ListBox.RowSource problem?

A

acc2008

I've been using access 2003 with vista for over a year with no problems,
however after a recent SP3 update a much utilised form that uses a list box
to display info has developed a rather strange problem it shows numerical and
date feilds but seems to miss out every text field.

I use VB extensively and have changed the properties of the list box over to
code and the same problem is still there?

The problem even appears when i use a 'Wizard created ListBox'

The created Table that the form produces has all the right info there and
when I debug the code behind it all the same info is in the respected fields,
so I've narrowed the problem down to the engine connecting the table to the
list box!

If anyone knows of any code to loop through a ListBox's items through the
debug window it would help to see into the problem a little as the Watch only
shows the last and first value, which incentally is a text field, so there
does seem to be a problem with the SP3 update by the looks of it.
 
J

Joan Wild

See
http://support.microsoft.com/kb/945674

--
Joan Wild
Microsoft Access MVP
: I've been using access 2003 with vista for over a year with no problems,
: however after a recent SP3 update a much utilised form that uses a list box
: to display info has developed a rather strange problem it shows numerical and
: date feilds but seems to miss out every text field.
:
: I use VB extensively and have changed the properties of the list box over to
: code and the same problem is still there?
:
: The problem even appears when i use a 'Wizard created ListBox'
:
: The created Table that the form produces has all the right info there and
: when I debug the code behind it all the same info is in the respected fields,
: so I've narrowed the problem down to the engine connecting the table to the
: list box!
:
: If anyone knows of any code to loop through a ListBox's items through the
: debug window it would help to see into the problem a little as the Watch only
: shows the last and first value, which incentally is a text field, so there
: does seem to be a problem with the SP3 update by the looks of it.
:
 
A

acc2008 via AccessMonster.com

Thanks Joan, I thought for the first time ever I was going to be beat by a
problem, looked high and low through MSDN Google etc for the same problem but
nothing ever came up in my searches.

Thanks again

Ray
 
J

Joan Wild

You're welcome; I gather that worked?

--
Joan Wild
Microsoft Access MVP
: Thanks Joan, I thought for the first time ever I was going to be beat by a
: problem, looked high and low through MSDN Google etc for the same problem but
: nothing ever came up in my searches.
:
: Thanks again
:
: Ray
:
: Joan Wild wrote:
: >See
: > http://support.microsoft.com/kb/945674
: >
:
: --
:
:
:
 
A

acc2008 via AccessMonster.com

Yes it did thanks!
Thought it was crazy when the values were always displayed in the watch but
never in the ListBox.

Joan said:
You're welcome; I gather that worked?

: Thanks Joan, I thought for the first time ever I was going to be beat by a
: problem, looked high and low through MSDN Google etc for the same problem but
[quoted text clipped - 6 lines]
: >See
: > http://support.microsoft.com/kb/945674
Click to expand...
 
Top