Combo Boxes

[Pwyd]

under what conditions would a query of a set of text values, when made a row
source for a combo box,return numerical values (the position within the list
of the query feeding the combo box) instead of the text values that are
located at each of those numbered positions?

1. Blah
2. Not blah


combo box shows 1/2 as options instead of Blah / Not Blah


......

 

[Tom van Stiphout]

On Wed, 29 Oct 2008 05:47:00 -0700, Pwyd

You could bind the combobox to a 2-column query, with the width of the
first column set to 0. This is a VERY common way to do it: computers
get (hidden) ID values, and humans get to see the corresponding text.

-Tom.
Microsoft Access MVP

 

[Pwyd]

It is currently done exactly as that. The query only returns the text. I
have no idea how the combo box is associating those values to numbers. When
showing the query results, its only results are the two text messages, one
per row.