Access 2002/3 Disappearing Combo Content

[Greg Fay]

In one particular database application using Access 2002
(and I'm also seeing it happen in 2003), I have a combo
box whose content becomes invisible when the form loses
focus and then reactivates. The entries are there; you
can even click them and the data is updated properly, but
you can't see them. Shifting the focus away from the
form and then back causes the list to reappear. Repaint
and/or Refresh doesn't help. Any suggestions as to the
cause?

 

[RobFMS]

Is the combo you are having troubles with rely on the data selected from
another combo? Is the combo being used in a continous datasheet?

If the answer to these questions is YES, then... yes, this is *the* behavior
you will get.


--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Greg]

The answer to your questions are No and No.

And let me refer you to a similar posted question under
the Forms Programming category by will eichert
called "Access 2003 problem with combo box..."

Thanks.

Greg

 

[Greg]

Sorry Rob--Will Eichert's post was at 3:15 p.m. on Jan
5th.

 

[will eichert]

Indeed this sounds like the same problem I'm having. So far I have no
responses to my post. I'll keep my eye on this thread, and if I find
out anything (not likely on my own, I've tried what little I know)
I'll post it here.

FWIW, for me the combo box is in the header section of a form viewed
in "FormView", Single Form (not continuous).

I'd really like to get this problem solved. Anyone?

Will

 

[Greg]

Thanks Will. I sent you an e-mail as well, and I'll let
you know if I figure anything out. So far it seems like
the common element is using Access 2002/3 as Access 2000;
however, it's not consistent. I run the same application
on my computer and the problem does not occur. It does
occur on 2 users computers that I know of (using Access
2002 and the database running as Access 2000). I'm
thinking I'll go convert the database to Access 2002 on
the user's computer and see if that makes any
difference. I'll let you know.

Greg

 

[Guest]

Will,

I was mistaken. We recently converted these users
databases to Access 2002 format. So I am having the
problem occur in Access 2002 databases using Access 2002
format. Now I don't know what the common elements are--
just that the combo box items become invisible after
another form receives the focuses. (We created a stupid
little work-around that opens a tiny form and then closes
it. The main form then repaints correctly.)

Greg