Prev: Can you add a tab control inside another tab control
Next: Add record(s) automatically
From: SteveL5231 on 25 Mar 2010 11:33
I have a form with a list box. Everything works fine except the contents of
the listbox don't display until I click on the listbox. Thoughts?
From: Maurice on 25 Mar 2010 15:09
Does the list have it's own rowsource? How do you set the rowsource?

When the listbox is bound to a rowsource it should display it's data as soon
as you open the form. Any other settings that might prevent it from being
filled...
--
Maurice Ausum


"SteveL5231" wrote:

> I have a form with a list box. Everything works fine except the contents of
> the listbox don't display until I click on the listbox. Thoughts?
From: SteveL5231 on 25 Mar 2010 16:21
The rowsource is a query.

"Maurice" wrote:

> Does the list have it's own rowsource? How do you set the rowsource?
>
> When the listbox is bound to a rowsource it should display it's data as soon
> as you open the form. Any other settings that might prevent it from being
> filled...
> --
> Maurice Ausum
>
>
> "SteveL5231" wrote:
>
> > I have a form with a list box. Everything works fine except the contents of
> > the listbox don't display until I click on the listbox. Thoughts?
From: Maurice on 25 Mar 2010 18:14
Ok, so the lisbox should display directly.

Try creating a new form with a new listbox created with the lisbox wizard
and save the form. Is the lisbox being filled as it should be?
--
Maurice Ausum


"SteveL5231" wrote:

> The rowsource is a query.
>
> "Maurice" wrote:
>
> > Does the list have it's own rowsource? How do you set the rowsource?
> >
> > When the listbox is bound to a rowsource it should display it's data as soon
> > as you open the form. Any other settings that might prevent it from being
> > filled...
> > --
> > Maurice Ausum
> >
> >
> > "SteveL5231" wrote:
> >
> > > I have a form with a list box. Everything works fine except the contents of
> > > the listbox don't display until I click on the listbox. Thoughts?
From: Dirk Goldgar on 25 Mar 2010 23:32
"SteveL5231" <SteveL5231(a)discussions.microsoft.com> wrote in message
news:17E2B1D1-2636-4A2B-8928-9EF1896F5FB2(a)microsoft.com...
>I have a form with a list box. Everything works fine except the contents
>of
> the listbox don't display until I click on the listbox. Thoughts?


Are you running Access 2003, and have you applied SP3, without applying the
post-SP3 hotfix? Does this KnowledgeBase article describe your problem?

http://support.microsoft.com/kb/945280/
Combo box controls and list box controls display no value or incorrect
values in Access 2003 after you install Office 2003 Service Pack 3

If that is the problem, the hotfix may fix it. You can find the hotfix
itself at:

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

But don't install that hotfix unless the above article really describes your
situation.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

 | 
Pages: 1
Prev: Can you add a tab control inside another tab control
Next: Add record(s) automatically