Cbo col2 -1/0 vs Yes/No 1

[zollo9999]

Hi
I'm using a combo box to display a list a staff, which the user selects. The combo has a row source set to a SQL query statement with 2 columns. The formatting is set to display the 2 columns when selecting a staff member.

The second column is a Yes/No field in the source table. It indicates Yes or No as to whether the staff member is an Assessment officer or not.

Previously, the cbo displayed Yes/No.
We have had a national migration to one consistent IT platform and most people in the offices that I support have had their PC re-imaged.

I have seen in 3 of our offices (including mine now today (just by chance I was travelling interstate for installation and training)) where instead of Yes or No, I'm getting -1 or 0.

The table is set to Yes/No format, but this is not coming through the SQL Statement. Previously it did work. What the difference is I don't know.

I will try converting the SQL into an access query to see if that works.

Any other suggestions?

Thanks in advance for any help

Zollo VBA Developer

http://msdn.microsoft.com/en-us/library/bb190882(office.11).aspx

 

[Remou]

Did this by any chance include a 2003 upgrade to sp3?

 

[zollo9999]

Hi Remou
Yes we are now running Access 2003 SP3.

It sounds like you know a bit about the impact of SP3 changes.
Anything you can add on this front?

Zollo VBA Developer

http://msdn.microsoft.com/en-us/library/bb190882(office.11).aspx

 

[PHV]

Have a look here:

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

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[zollo9999]

Hi PHV
Thanks
This hotfix exactly addresses this issue.
I have requested the hotfix be tested and installed on all our desktops.

I'll give you a star for this tip.
Paul

Zollo VBA Developer

http://msdn.microsoft.com/en-us/library/bb190882(office.11).aspx