Combo Box list error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I have a combo box on a form pulling data from a table. When I click on the
combo box, the first 4 items are blank. The 5th item is where the actual data
from the table starts to be listed. I checked the table and it does not have
blank records. How do I fix this? Why is this happening?
-me
 
how did you "check the table"? did you a do an Ascending (and then
Descending) sort on that field in table datasheet view? or did you run an
query with Is Not Null criteria on that field? if the latter, try the
former. it could be that those four "blank" records actually have a
zero-lenth string in them. suggest you make sure the Allow Zero Length
property in all your Text, Memo, and Hyperlink fields is set to No, in all
your tables.

hth
 
Hello Tina,
I viewed table2 in datasheet view. It only has 12 records so far.
Table1 has around 30 records.

Before I started entering data on form1 and the combo box, I did not have
referencial entegrity checked. I entered some 30 records. I then deleted the
pk on table2 and created a new pk. I believe the problem is table1
I managed to fix the problem by making a copy of table1 without the data.
It only contained sample data anyway.
Thank you.
-me
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting combo box drop-down list 1
Combo Box help 0
cascading combo box 20
Retain combo box order 1
Bound form & blank combo box 3
combo box goes blank? 6
Filtering a combo box using a combo box 2
How to set different combo box values for new record? 6

Back
Top