[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 649
  • Last Modified:

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
0
denver5o
Asked:
denver5o
  • 5
  • 4
1 Solution
 
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 new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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
 
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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now