Article ID: 945280 - View products that this article applies to.
Consider the following scenario:
Symptom 1The control displays no value. However, you expect the control to display values from the field that is returned by the SQL statement.
Symptom 2The control displays -1 for the Yes value and 0 for the No value. However, you expect the control to display Yes for the Yes value and No for the No value.
These symptoms do not occur in versions of Access 2003 earlier than Access 2003 with Office 2003 SP3.
Cause 1This problem occurs when one of the following conditions is true:
Cause 2This problem occurs when the SQL statement returns a field whose data type is Bit. To work around this problem, see Workaround 2.
Workaround 1To work around this problem, use one of the following methods, depending on the cause of the problem.
Method 1Remove the display format that you set for this field. To do this, follow these steps.
Note Use this method when the first condition of the "Cause 1" section is true.
Method 2Update the SQL statement to append "" to the field for the Row Source property. To do this, follow these steps.
Note Use this method when the second condition of the "Cause 1" section is true.
For example, the original SQL statement is as follows:
You update the SQL statement as follows:
Note When you import columns that have the Text property from an Excel worksheet, Access 2003 automatically sets the display format to the @ (at sign) character for the corresponding fields.
Workaround 2To work around this problem, follow these steps:
Collapse this tableExpand this table
To resolve this problem, obtain the Access 2003 post-Service Pack 3 hotfix package that is dated December 18, 2007. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/945674/ )Description of the Access 2003 post-Service Pack 3 hotfix package: December 18, 2007
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Contact us for more help
Connect with Answer Desk for expert help.