Combo Box doesn't display selected item (ACC 2003 to 2000)

I am working with an Access Data Project against MSDE. I have a simple combo box with Row Type set to Value List. The Row Source is as follows: "1 Month";"6 Months";"1 Year". This is an unbound control. Limit to List is set to Yes. Column Count is set to 1.

I have a command button that executes some code based on the selected value.

The combo box and command button are in the form header. The form is set to Continuous Form to display multiple records based on the combo box selection.

When I run the application in my dev environment (Laptop with Windows XP Pro, Office 2003 but using Access 2000 Format), selecting an item in the drop down list closes the drop down portion and displays the user's selection in the textbox portion of the drop down.

When I run the in the production environment (Windows 2000 Server or Windows XP Pro, Office 2000), selecting the item closes the drop down list but the textbox portion is blank. This is only an appearance issue as when I press the command button, I have verified that the combo box is set to the correct value.

It looks like this is a compatibility problem between Access 2000 controls and Access 2003 controls (even when saved to 2000 format)

Does anyone know about this problem and how to resolve it?

For now I'll probably just change the combo box to a list box or radio buttons.

Thanks.

ZLA

Hi ZLA,

I don't know if this will help or not, but I have encountered similar problems that were isolated back to some conditional formatting to one of the controls or the form itself. Take a look at style themes that are used etc., or some conditional format that may not cross over between the two versions of Office. Working with Access 2003 formatted in Access 2000 is where I have seen this happen in my own applications. One of the work arounds that I used was to display WindowsXP in the classic view rather than the XP view. For some reason this seemed to solve the problems I had. I think it has to do with displaying Access 2000 format in the XP view. I believe if you were to save your project as Access 2003, you wouldn't have this issue, but obviously would have to have Office 2003 installed in your production environment.

Post back to what you find.
lwells