By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,269 Members | 1,506 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,269 IT Pros & Developers. It's quick & easy.

Service Pack 3 & Combo box problem

P: n/a
Hi,

I decided to install Office 2003 Service Pack 3 on my home computer to test
(in full knowledge that there may be some issues with it). After installation,
I have noticed that with a small database I wrote for home, the combo boxes
and listboxes no longer display the bound column. For example, on a form I
have a combo box based on a table called 'names'. The two columns in the
combo box are ID and Surname. The combo box and list box show two columns but
the first (bound) column is blank. If I open the form in my database above
and create a new combo box, the bound column is not displayed but if I create
a new database and create a new form and combo box based on a table with
dummy data, the combo box displays correctly.

Prior to installing Service Pack 3, they were displaying correctly.

I would appreciate any suggestions/advice.

Thanks
Anthony

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200709/1

Sep 19 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Sky

I just posted a similar question in microsoft.public.access.modulesdaovba.
If you have custom formatting on the fields in the underlying tables for the
RowSource, you might try removing the custom formatting.

Here was my post:

I just installed the new Service Pack 3 for Office 2003.

This has caused a strange display problem in Access 2003 with combo boxes on
tables that have a formatted text field.

To see this problem, create a table named TableX with a single key field
FieldX that is a text field. (Use any table name or field name you like.)
Add a few rows of data, such as a, b, c.

Create a simple test form with a combo box that has SQL such as "Select
FieldX From TableX". Save the form. The combo box dropdown displays just
fine and you can select values.

Now go to design view on TableX and change the format property of FieldX
to have any format, such as &[Blue]. (This particular format displays the
FieldX in a blue color, which I use to indicate key fields during
development,
and it propagates to queries. But any format seems to cause the problem.
The users, of course, always view data in forms.)

Suddenly the combo box on the test form is completely blank. The combo box
does have data (for example, from the Immediate Window,
?Screen.ActiveControl.ListCount has the correct value of 3),
but the display is all blank and you cannot actually see any of the dropdown
rows.

It does not matter what format is applied to FieldX, or whether the form
combo box has formatting or not, the combo dropdown is blank.

The formatting on FieldX should have nothing to do with the combo box
display.

But for some reason, the field format interferes with the combo box display.

Prior to Service Pack 3, this was never an issue. (Nor was it ever an issue
in prior versions of Access.) Am I missing something? Any suggestions for a
work-around?
"biganthony via AccessMonster.com" <u31673@uwewrote in message
news:78722d8c68020@uwe...
Hi,

I decided to install Office 2003 Service Pack 3 on my home computer to
test
(in full knowledge that there may be some issues with it). After
installation,
I have noticed that with a small database I wrote for home, the combo
boxes
and listboxes no longer display the bound column. For example, on a form I
have a combo box based on a table called 'names'. The two columns in the
combo box are ID and Surname. The combo box and list box show two columns
but
the first (bound) column is blank. If I open the form in my database above
and create a new combo box, the bound column is not displayed but if I
create
a new database and create a new form and combo box based on a table with
dummy data, the combo box displays correctly.

Prior to installing Service Pack 3, they were displaying correctly.

I would appreciate any suggestions/advice.

Thanks
Anthony

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200709/1

Sep 19 '07 #2

P: n/a
I took the custom formatting out from the underlying tables and the combo box
and the list box works as expected. I also tried Ken Snell's solution and it
worked.

Hope there will be a fix

Anthony
biganthony wrote:
>Thanks for the replies. I will try tonight the solution offered. I am using
Windows XP x64 Edition SP2.

Regards
Anthony
>>Ken Snell suggested this work-around in
microsoft.public.access.modulesdaovba:
[quoted text clipped - 16 lines]
>>>Thanks
Anthony
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200709/1

Sep 20 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.