List box in MS Access form does not show text

I have a form that works fine except in one degree: the list of choices on the first listbox does not appear when you click the down arrow or otherwise try to look at them. The choice are in there, though, because when you select one of them, it populates the box just fine - in black and white.

I first suspected a problem with font color contrasting with the background, but that wasn't it. I made the text color for the field black and the background grey, and that didn't change anything.

Seems like a strange problem, but hopefully easy to run down. I'll attach some screenshots as well so you can see what I'm seeing.
BlankListBox1.JPG
BlankListBox2.JPG
denver5oAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mbizupCommented:
What is the SQL for your rowsource query?  
Do you have multiple blanks/nulls at the beginning of the list, with data following that (if that is the case, try SELECT DISTINCT blah blah blah)?

Also check your column widths...
0
TextReportCommented:
The first thing to look at are the Row Source, Column Count, Column Widths and Bound Column
Cheers, Andrew
0
denver5oAuthor Commented:
Here are some details from the control:

ROW SOURCE: Table/Query
ROW SOURCE: SELECT DISTINCT tblValidEmployees.Employee FROM tblValidEmployees
COLUMN COUNT: 1
COLUMN HEADS: No
COLUMN WIDTHS: 1"
BOUND COLUMN: 1
LIST ROWS: 8
LIST WIDTH: 1"
LIMIT TO LIST: Yes
AUTO EXPAND: YES
...
DISPLAY WHEN: Always
...
BACK COLOR: 16777215
....
FORE COLOR: 0

Hope that helps!
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

TextReportCommented:
What records do you get when you run the SQl?
Cheers, Andrew
0
denver5oAuthor Commented:
Good question. 32 records are returned.

I should also note that the original image above shows exactly where I selected the "choice," and the second image shows what was returned. So I'm not hitting early blanks... there really are definite values hiding behind each of these blank spaces!
0
TextReportCommented:
Try and remove the Column Widths and set the List Width to Auto
Try showing Column Heads

Then if that fails change the SQl to
SELECT DISTINCT "AAA" & [tblValidEmployees].[Employee] FROM tblValidEmployees

Cheer, Andrew
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
denver5oAuthor Commented:
Okay, that created some interesting results...

Changing the Column and List Widths did nothing, but...
showing Column Heads at least listed the name of the column at the top...
and adding "AAA" to the Employee names made everything show up.

I took out the "AAA" and just used
SELECT DISTINCT "" & [tblValidEmployees].[Employee] FROM tblValidEmployees
and it all looks fine.

The only nagging question is "Why?"!!!

Many thanks,

    Dave


0
TextReportCommented:
Sometime you just have to not WHY but Oh well!! Honest answer, I don't know but you were only a few steps from having to delete the combo and redo.

Now if you put the SQL back does it fail again?

Cheers, Andrew
0
denver5oAuthor Commented:
Strangely enough, it continues to fail when I take out the empty string in front of the selection query.

Why ask why, I guess...

I's certainly hard not to know why, but at least it's working. Many thanks!!
0
denver5oAuthor Commented:
Thanks so much for your creative troubleshooting!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.