Hi, Sam.
I have a list box populated with a pass-through query. The list box is empty
when the form opens. This just started happening. A couple of days ago the
List box displayed selections.
The list box is unbound.
The rowSource property displays the correct query.
Any thoughts as to what to look at?
Things to check:
1.) If the Row Source displays the correct query name, then does this query
currently return records? Check the query's Returns Records Property. It
should be Yes. (Go ahead and run the query to verify that records are
displayed in the query.)
2.) Is the Row Source Type set to Table/Query?
3.) Does the Column Count include at least one column in the query that is
wide enough to be visible? (0.01" isn't wide enough for the Column Widths,
but something a little wider than this would have a noticeable vertical line,
but not necessarily visible text.)
4.) Is the Font Color Property different from the Back Color Property? Can
you read the word Unbound in the first line of the list box while in Design
View?
5.) Is the Font Size large enough to be seen? Again, the word Unbound will
show you if it's big enough.
6.) Does the Form's module have VBA code that changes any of these
properties to something that affects the display of the contents of the list
box?
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. (Only "Answers" have green
check-marks.) Remember that the best answers are often given to those who
have a history of rewarding the contributors who have taken the time to
answer questions correctly.
