why is my combo box blank?

B

Bob Quintal

I have a combo box on a switchboard tab that doesn't show any
data. I can scroll down and select a line (that appears to be
blank) and the data shows up in the combo box like it should. It
works fine in Access 2000, but doesn't work in Access 2003. The
code is

SELECT tblEquipment.txtEquipNumber FROM tblEquipment ORDER BY
tblEquipment.txtEquipNumber;

I have also tried building a query and directing the combo box to
that instead of the above code... The data appears to be there,
you just can't see it. This is also a problem on a form that pulls
up data in a subform.

Strange this is that on another tab of the switchboard, this seems
to work fine (when pulling up information by employee).

I'm stumped! Please help!
Click to expand...
This is probably due to a known bug in Access XP Service Pack 3.
tblEquipment.txtEquipNumber has a format property in the table. The
employee field does not.
Quick fix, change the row source on the combobox to
SELECT tblEquipment.txtEquipNumber & "" AS txtEquipNumber....
 
G

Guest

I have a combo box on a switchboard tab that doesn't show any data. I can
scroll down and select a line (that appears to be blank) and the data shows
up in the combo box like it should. It works fine in Access 2000, but doesn't
work in Access 2003. The code is

SELECT tblEquipment.txtEquipNumber FROM tblEquipment ORDER BY
tblEquipment.txtEquipNumber;

I have also tried building a query and directing the combo box to that
instead of the above code... The data appears to be there, you just can't see
it. This is also a problem on a form that pulls up data in a subform.

Strange this is that on another tab of the switchboard, this seems to work
fine (when pulling up information by employee).

I'm stumped! Please help!
 
G

Guest

Thanks so much! That worked perfectly! Not sure what that does so I'm not
sure how to apply that to

SELECT qselEquipmentMonitorbySerialNo.txtEquipNumber,
qselEquipmentMonitorbySerialNo.txtSerialNo FROM
qselEquipmentMonitorbySerialNo;

?
 
G

Guest

OK, so I got it figured out... this is very convoluted! WOW!!!

Here's what I ended up with...

SELECT qselEquipmentMonitorbySerialNo.txtEquipNumber & "" AS txtEquipNumber,
qselEquipmentMonitorbySerialNo.txtSerialNo & "" AS txtSerialNumber FROM
qselEquipmentMonitorbySerialNo;

I appreciate the help!
 
G

Guest

Don't forget that with SP3 of Office2003 a bug was introduced where the combo
box lists looked empty if the original field had any formatting eg > for
captilisation.
Mary
 
G

Guest

The formatting issue may have been part of the cause for the EquipID
problem... not sure, but the concatenation did fix it... Wonder if that's
why the Employee one worked (it's already been concatenated in a query...)

Thanks for all the help (especially the speed of the help!) Really saved my
day!
 
O

opeyemi

my windows media payer11 is ot giving me video output.what can i do,am using
windows vista.
 
L

Larry Linson

opeyemi said:
my windows media payer11 is ot giving me video output.what can i do,am
using windows vista.
Click to expand...

Ask in a newsgroup dedicated to Windows or Windows Media Player, and you'll
stand a better chance of getting a useful answer. This newsgroup is for
discussion of and questions and answers about, Micosoft Access database
software, the database part of Microsoft Office.

Larry Linson
Microsoft Access MVP
 
B

Barbara Diehl

I recently installed a lexmark x1270 printers to my acer aspire 3680 laptop
and now it keeps telling me I need to install it. I put the CD in a 2nd time
after I installed it to see what the warranty was and now it keeps asking me
to install my printer???
 
D

Doz

An even quicker fix... go into the table and remove any formatting in the
table design view. I had ">" for capitalisation in there... removed it and
it was fixed.
 
P

Pieter

I hope somebody reads this, since this forum thread is more than a year old..
:). I experience the same problems, and the fix works. However, on my tables
I have both a formatting restriction and an input mask and I want them to
stay. My problem is that in my combobox the formatting is gone after using
this fix.

I am also using Access 2003, and a database recently converted from Access
97 format (that might make a difference).

So I have a database field name 'Offertenummer' (offer number in dutch) with
the following format:
@@\.@@@@
and consequently, this input mask:
00\.0000
(two numbers, a dot and then four numbers)
And I want this notation to appear in the combobox.

Can anybody help me with this? The concatenation fix helps, because instead
of showing nothing it shows the number without the dot, but it's not perfect
yet.

As I said I recently converted the database from 97 to 2002-2003 format, and
in the old database format (opening it in Access 97 or 2000) the combobox
worked fine.

Thanks a lot in advance!

Regards,
Pieter

Bob Quintal said:
An even quicker fix... go into the table and remove any
formatting in the table design view. I had ">" for capitalisation
in there... removed it and it was fixed.
Click to expand...
Quicker is debatable. If you have to set the format in the 20 other
places that field appears in the database's queries, forms and
reports or write, validate then run an update query to force
capitalization on the existing data and create and debug an input
mask for new additions to that field, I suspect that removing the
format from the table will not be a quicker fix.

Q
Click to expand...
 
D

Dirk Goldgar

Pieter said:
I hope somebody reads this, since this forum thread is more than a year
old..
:). I experience the same problems, and the fix works. However, on my
tables
I have both a formatting restriction and an input mask and I want them to
stay. My problem is that in my combobox the formatting is gone after using
this fix.

I am also using Access 2003, and a database recently converted from Access
97 format (that might make a difference).

So I have a database field name 'Offertenummer' (offer number in dutch)
with
the following format:
@@\.@@@@
and consequently, this input mask:
00\.0000
(two numbers, a dot and then four numbers)
And I want this notation to appear in the combobox.

Can anybody help me with this? The concatenation fix helps, because
instead
of showing nothing it shows the number without the dot, but it's not
perfect
yet.

As I said I recently converted the database from 97 to 2002-2003 format,
and
in the old database format (opening it in Access 97 or 2000) the combobox
worked fine.

Thanks a lot in advance!
Click to expand...


Pieter, is your problem the oine described here:

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 so, have you installed this hotfix:

http://support.microsoft.com/kb/945674
Description of the Access 2003 post-Service Pack 3 hotfix
package: December 18, 2007

?
 
P

Pieter

Hi Dirk,

Sorry for the late reply, your proposed solution did work excellent :).
During conversion Access also gave some errors about old DAO-syntax which
could cause problems.. I was looking totally in the wrong direction. Thanks
for the help!

Regards, Pieter
 
D

Dirk Goldgar

Pieter said:
Hi Dirk,

Sorry for the late reply, your proposed solution did work excellent :).
During conversion Access also gave some errors about old DAO-syntax which
could cause problems.. I was looking totally in the wrong direction.
Thanks
for the help!
Click to expand...


I'm glad to have helped.
 

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

Search using combo box 7
Combo Box Question 4
Combo Box Help 7
Blank combo or list box 1
blank combo box 3
Combo Box 2
Too many forms? 3
Blank combo box 4

Top