Combo box blank column

[Rob]

Hi all,

I have a very simple combo box that has a query as its source. The query is
very simple and draws an ID and a Title from a single table. The query runs
as expected, however when I attempt to display it in a combo box, it only
displays the ID and not the title.

This is driving me nuts so any assistance would be appreciated. Access 2003
on WinXp Professional (Version 2002) SP3. The combo box is on an unbound
form, and is part of an option group (although I do not think that this has
any affect as the behaviour is repeated on another combo box on the form!).

Cheers
Rob

The query is:

SELECT tblTasks.taskID, tblTasks.taskTitle
FROM tblTasks
GROUP BY tblTasks.taskID, tblTasks.taskTitle, tblTasks.taskAssignedTo
HAVING (((tblTasks.taskAssignedTo)=GetGlobals("PositionID")));

 

[Rob]

Hi all,

Problem solved. I was thinking on the differences since last build and
voila - Office SP3 Combo Box fix. I suppose that this means I will have to
set the format for that field in each of the forms that it is used!

Cheers
Rob