list box data not displaying correctly

  • Thread starter Thread starter JK
  • Start date Start date
J

JK

I'm in the process of rolling out a new version of my db to a number of
users. These users have been using the db for some time now. Everything
appears to be working as intended except one thing.

I have a number of forms that contain list boxes. If the user wants to view
a company, they click the Companies command button and then a form is
displayed with a list box containing all of the companies in the db.

For some reason, these list boxes are not displaying the data correctly. For
example, the companies list box contains the company name, the city, and the
state (3 columns.) When the form is opened by the user only the city data is
being displayed correctly. The company name is blank or invisible and the
state is blank or invisible.

This is happening on a number of forms that contain list boxes. However, not
all of them - just some of them! Some are working correctly.

Any ideas what might be causing this? I'm kinda in a jam right now and could
really use some help.

Thanks,
Jason
 
One thing I can think of - before deploying I unchecked each reference and
then compiled the VBA - if the compile completed without an error I left the
reference unchecked - assuming if the reference was required the compile
would not have completed (not sure if that's true or not.) I'm also making
sure the backend of the split db has all of the same references as the front
end even though there is very little code in the backend - are these
references in the backend required? Or, can the backend references be
different from the frontend?

Anyway, the references I removed are as followed:

1. Microsoft Office Web Components Wizards
2. Microsoft Visual Basic for Applications Extensibility 5
3. Windows Media Player

I'm also using Microsoft Office 11.0 object library (which is selected in FE
& BE)

Could any of the references I removed affect the data being displayed in a
list box?

The problem here - the data is being displayed correct on my computer just
not the end user's computers. On their computers the certain columns are not
being displayed. Some are - some aren't.

Need help.

Thx,
Jason
 
Here is a good overview of MS Access ListBoxes:
http://www.fontstuff.com/access/acctut11.htm


Example, to display the value from the 3rd column in the ListBox, set the
Control Source to:

=lstListbox.Column(2)
Yes, 2 will display the 3rd column, the number is zero based.

Also, be aware that a ListBox can have multiple columns of data. You use
the "ColumnWidths" property to set the width of the individual columns. A
zero width column results in a column of hidden data.

Finally, pay attention to ColumnCount and ColumnWidths, as seen in the video
here:
http://www.datapigtechnologies.com/flashfiles/combobox3.html


HTH,
Ryan---
 
Ok, I discovered the problem. In the queries behind the list boxes, I have
set formatting options. I wanted all of the data being displayed in the list
boxes to be in upper-case (caps.) So in the query field properties I have
inserted a ">" w/o quotes in the format field.

Now on my computer this works perfectly but on other comptuers it does not.
On the other compters the data does not display at all. If I remove the ">"
from the query field properties format section the data is displayed
correctly.

Any idea why this is happening? Do I need to go though every query to remove
the formatting options [nightmare & time-consuming.]

Thanks!
Jason
 
I believe that is a bug in Access 2003 caused by Service Pack 3.

Check out
http://allenbrowne.com/bug-Access2003SP3.html

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
Ok, I discovered the problem. In the queries behind the list boxes, I have
set formatting options. I wanted all of the data being displayed in the list
boxes to be in upper-case (caps.) So in the query field properties I have
inserted a ">" w/o quotes in the format field.

Now on my computer this works perfectly but on other comptuers it does not.
On the other compters the data does not display at all. If I remove the ">"
from the query field properties format section the data is displayed
correctly.

Any idea why this is happening? Do I need to go though every query to remove
the formatting options [nightmare & time-consuming.]

Thanks!
Jason

JK said:
I'm in the process of rolling out a new version of my db to a number of
users. These users have been using the db for some time now. Everything
appears to be working as intended except one thing.

I have a number of forms that contain list boxes. If the user wants to view
a company, they click the Companies command button and then a form is
displayed with a list box containing all of the companies in the db.

For some reason, these list boxes are not displaying the data correctly. For
example, the companies list box contains the company name, the city, and the
state (3 columns.) When the form is opened by the user only the city data is
being displayed correctly. The company name is blank or invisible and the
state is blank or invisible.

This is happening on a number of forms that contain list boxes. However, not
all of them - just some of them! Some are working correctly.

Any ideas what might be causing this? I'm kinda in a jam right now and could
really use some help.

Thanks,
Jason
Click to expand...
Click to expand...
 
Thanks for your help guys - I couldn't do what I do without your help. It's
very much appreciated.

And yes, I believe the hotfix will correct the issue. The problem was with
the end-users PC - my PC displays the data in the listbox correctly. I have
the hotfix installed - the end user does not.

Jason
 
Back
Top