data in second column not showing in Drop Down - first (ID) field

G

Guest

I have a combo box to look up a value from a table

Table is called Symbols and has 2 columns:
Symbol_ID (autonum)
Symbol (text)

Sample data:

Symbol_ID Symbol
56 SM_SWITCH_14PIN
57 SM_SWITCH_16PIN
59 CONNECTOR_24PIN
61 SM_SWITCH_4PIN

SELECT Symbols.Symbol_ID, Symbols.Symbol FROM Symbols
ORDER BY [Symbol];

I have set the column widths for the combo to 1";1"
I can see the Symbol ID but nothing is showing for the text in the Symbol
field

I tried creating a query from the table and using that as the source instead
of the table and the same thing happens.

SELECT Query2.Symbol_ID, Query2.Symbol FROM Query2 ORDER BY [Symbol];

When I view the query, I can see data in both fields.

I have had this drop down in my form for years and now suddenly it shows
nothing. Even the field (a lookup) in the table itself is blank.

any ideas?

thanks
sandy
 
J

Jeff Boyce

You don't mention which version of Access you are using.

There's a recently reported bug that cropped up with comboboxes in Access
2003 when SP3 was applied. If I recall, it had to do with Format properties
being set at the table level (check Google for details, using some of those
keywords).

You didn't mention whether your combobox is set to display two columns, just
the the query returns two. You could set the column widths at 1,1, but if
you said there was only one column, ...

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
G

Guest

Hi Jeff -

I am running Access 2003 with SP3.

To test this issue, I created a new form with a combo box to display both
columns and only the first column shows any data.

I googled and it seems that I have to remove then re-install Office 2003
with SP2 and all updates until SP3 or do a System Restore.

Thanks!
sandy


Jeff Boyce said:
You don't mention which version of Access you are using.

There's a recently reported bug that cropped up with comboboxes in Access
2003 when SP3 was applied. If I recall, it had to do with Format properties
being set at the table level (check Google for details, using some of those
keywords).

You didn't mention whether your combobox is set to display two columns, just
the the query returns two. You could set the column widths at 1,1, but if
you said there was only one column, ...

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP


Sandy said:
I have a combo box to look up a value from a table

Table is called Symbols and has 2 columns:
Symbol_ID (autonum)
Symbol (text)

Sample data:

Symbol_ID Symbol
56 SM_SWITCH_14PIN
57 SM_SWITCH_16PIN
59 CONNECTOR_24PIN
61 SM_SWITCH_4PIN

SELECT Symbols.Symbol_ID, Symbols.Symbol FROM Symbols
ORDER BY [Symbol];

I have set the column widths for the combo to 1";1"
I can see the Symbol ID but nothing is showing for the text in the Symbol
field

I tried creating a query from the table and using that as the source
instead
of the table and the same thing happens.

SELECT Query2.Symbol_ID, Query2.Symbol FROM Query2 ORDER BY [Symbol];

When I view the query, I can see data in both fields.

I have had this drop down in my form for years and now suddenly it shows
nothing. Even the field (a lookup) in the table itself is blank.

any ideas?

thanks
sandy
 
J

Jeff Boyce

Actually, what I understood was that it was enough to remove the Format-ing
on the underlying table fields...

Let us know if your approach works.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Sandy said:
Hi Jeff -

I am running Access 2003 with SP3.

To test this issue, I created a new form with a combo box to display both
columns and only the first column shows any data.

I googled and it seems that I have to remove then re-install Office 2003
with SP2 and all updates until SP3 or do a System Restore.

Thanks!
sandy


Jeff Boyce said:
You don't mention which version of Access you are using.

There's a recently reported bug that cropped up with comboboxes in Access
2003 when SP3 was applied. If I recall, it had to do with Format
properties
being set at the table level (check Google for details, using some of
those
keywords).

You didn't mention whether your combobox is set to display two columns,
just
the the query returns two. You could set the column widths at 1,1, but
if
you said there was only one column, ...

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP


Sandy said:
I have a combo box to look up a value from a table

Table is called Symbols and has 2 columns:
Symbol_ID (autonum)
Symbol (text)

Sample data:

Symbol_ID Symbol
56 SM_SWITCH_14PIN
57 SM_SWITCH_16PIN
59 CONNECTOR_24PIN
61 SM_SWITCH_4PIN

SELECT Symbols.Symbol_ID, Symbols.Symbol FROM Symbols
ORDER BY [Symbol];

I have set the column widths for the combo to 1";1"
I can see the Symbol ID but nothing is showing for the text in the
Symbol
field

I tried creating a query from the table and using that as the source
instead
of the table and the same thing happens.

SELECT Query2.Symbol_ID, Query2.Symbol FROM Query2 ORDER BY [Symbol];

When I view the query, I can see data in both fields.

I have had this drop down in my form for years and now suddenly it
shows
nothing. Even the field (a lookup) in the table itself is blank.

any ideas?

thanks
sandy
 

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

Top