Combo box not showing field

[Mary Fran]

This is a problem that is happening on several computers but not mine. The
user hits the dropdown and a field that is supposed to show doesn't. I know
we have the same front end b/c they sent me the one on which they're
experiencing this problem.
Here is the row source for the combo (again, it works fine on my computer
but on theirs the CourseID does not show):
SELECT tblcCourses.CourseID, tblcCourses.Course,
IIf(IsNull([CourseName]),"Course Name not available",[CourseName]) AS
CourseMenu,
DCount("[CourseID]","[qryCurrentTutorsAthletesCourses]","[CourseID] = " &
[CourseID]) AS Courses
FROM tblcCourses
ORDER BY tblcCourses.Course;

Can anyone help, please?!

 

[KARL DEWEY]

Check the column count, width, and bound column.

 

[Mary Fran]

They are all correct and match what I have in mine - everything is exactly
the same but theirs doesn't work. And to elaborate further, if you create
that same combo box on a blank form they get the same behavior - the first
field shows as a blank (it gets the width allotted but no data).

Check the column count, width, and bound column.
--
KARL DEWEY
Build a little - Test a little

This is a problem that is happening on several computers but not mine. The
user hits the dropdown and a field that is supposed to show doesn't. I know
we have the same front end b/c they sent me the one on which they're
experiencing this problem.
Here is the row source for the combo (again, it works fine on my computer
but on theirs the CourseID does not show):
SELECT tblcCourses.CourseID, tblcCourses.Course,
IIf(IsNull([CourseName]),"Course Name not available",[CourseName]) AS
CourseMenu,
DCount("[CourseID]","[qryCurrentTutorsAthletesCourses]","[CourseID] = " &
[CourseID]) AS Courses
FROM tblcCourses
ORDER BY tblcCourses.Course;

Can anyone help, please?!

 

[KARL DEWEY]

What do you get if you run the select statement in a query (not in the combo)?

--
KARL DEWEY
Build a little - Test a little

They are all correct and match what I have in mine - everything is exactly
the same but theirs doesn't work. And to elaborate further, if you create
that same combo box on a blank form they get the same behavior - the first
field shows as a blank (it gets the width allotted but no data).

Check the column count, width, and bound column.
--
KARL DEWEY
Build a little - Test a little

This is a problem that is happening on several computers but not mine. The
user hits the dropdown and a field that is supposed to show doesn't. I know
we have the same front end b/c they sent me the one on which they're
experiencing this problem.
Here is the row source for the combo (again, it works fine on my computer
but on theirs the CourseID does not show):
SELECT tblcCourses.CourseID, tblcCourses.Course,
IIf(IsNull([CourseName]),"Course Name not available",[CourseName]) AS
CourseMenu,
DCount("[CourseID]","[qryCurrentTutorsAthletesCourses]","[CourseID] = " &
[CourseID]) AS Courses
FROM tblcCourses
ORDER BY tblcCourses.Course;

Can anyone help, please?!

 

[Mary Fran]

It works fine in the query (if you mean the query that comprises the
rowsource of the combo box - if you click on the 3 dots to build the query
the fields show as expected) - it's only when you click the dropdown arrow of
the combo box that you get blanks in the "bad" field and it shows as a blank
after selecting it - the only way you'd know you got the correct data is
that we have another column from the query showing next to the combo box.
Again, this happens only on their computers - not on mine. Any more ideas?

What do you get if you run the select statement in a query (not in the combo)?

--
KARL DEWEY
Build a little - Test a little

They are all correct and match what I have in mine - everything is exactly
the same but theirs doesn't work. And to elaborate further, if you create
that same combo box on a blank form they get the same behavior - the first
field shows as a blank (it gets the width allotted but no data).

Check the column count, width, and bound column.
--
KARL DEWEY
Build a little - Test a little


:

This is a problem that is happening on several computers but not mine. The
user hits the dropdown and a field that is supposed to show doesn't. I know
we have the same front end b/c they sent me the one on which they're
experiencing this problem.
Here is the row source for the combo (again, it works fine on my computer
but on theirs the CourseID does not show):
SELECT tblcCourses.CourseID, tblcCourses.Course,
IIf(IsNull([CourseName]),"Course Name not available",[CourseName]) AS
CourseMenu,
DCount("[CourseID]","[qryCurrentTutorsAthletesCourses]","[CourseID] = " &
[CourseID]) AS Courses
FROM tblcCourses
ORDER BY tblcCourses.Course;

Can anyone help, please?!

 

[KARL DEWEY]

What I meant for you to was to create a new query in design view, change to
SQL view, and paste the select statement in the SQL window. Then run the
query.
--
KARL DEWEY
Build a little - Test a little

It works fine in the query (if you mean the query that comprises the
rowsource of the combo box - if you click on the 3 dots to build the query
the fields show as expected) - it's only when you click the dropdown arrow of
the combo box that you get blanks in the "bad" field and it shows as a blank
after selecting it - the only way you'd know you got the correct data is
that we have another column from the query showing next to the combo box.
Again, this happens only on their computers - not on mine. Any more ideas?

What do you get if you run the select statement in a query (not in the combo)?

--
KARL DEWEY
Build a little - Test a little

They are all correct and match what I have in mine - everything is exactly
the same but theirs doesn't work. And to elaborate further, if you create
that same combo box on a blank form they get the same behavior - the first
field shows as a blank (it gets the width allotted but no data).

:

Check the column count, width, and bound column.
--
KARL DEWEY
Build a little - Test a little


:

This is a problem that is happening on several computers but not mine. The
user hits the dropdown and a field that is supposed to show doesn't. I know
we have the same front end b/c they sent me the one on which they're
experiencing this problem.
Here is the row source for the combo (again, it works fine on my computer
but on theirs the CourseID does not show):
SELECT tblcCourses.CourseID, tblcCourses.Course,
IIf(IsNull([CourseName]),"Course Name not available",[CourseName]) AS
CourseMenu,
DCount("[CourseID]","[qryCurrentTutorsAthletesCourses]","[CourseID] = " &
[CourseID]) AS Courses
FROM tblcCourses
ORDER BY tblcCourses.Course;

Can anyone help, please?!

 

[John W. Vinson]

It works fine in the query (if you mean the query that comprises the
rowsource of the combo box - if you click on the 3 dots to build the query
the fields show as expected) - it's only when you click the dropdown arrow of
the combo box that you get blanks in the "bad" field and it shows as a blank
after selecting it - the only way you'd know you got the correct data is
that we have another column from the query showing next to the combo box.
Again, this happens only on their computers - not on mine. Any more ideas?

This sounds like one of the problems introduced in A2003 SP3. Here's my friend
Tony Toews' message about this problem:

"Combo box controls and list box controls display no value or
incorrect values in Access 2003 after you install Office 2003 Service
Pack 3." And a few more problems SP3 introduced.

Description of the Access 2003 post-Service Pack 3 hotfix package:
December 18, 2007 - 945674

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

The free hotfix on the Support site seems to resolve the issue, as does
removing any Format property on the fields in the combo's rowsource.

John W. Vinson [MVP]