combo box - bound column

[Mark Kubicki]

I have a combo box that is not functioning as I would expect:

- its row source has 2 columns: [Note] and [NoteTitle] (this is the order
in the datasource query)
- I have the bound column set to: 1, column count: 2, and column widths:
0",4"
- a value from the combobox can be selected (only column 2 is visible, which
is correct), however, the value entered into the bound field is that of
column 2 [NoteTitle], not column 1 [Note]

both the row source, and the bound control source are memo fields; it is
absolutely necessary to have more than the 255 limit of a text field (could
this be the problem?)

much thanks in advance,
mark

 

[Mark Kubicki]

never mind... I found the problem:
I'm trying to display the bound value (which is binding correctly). this is
not how a combo box works... (correct?)
-mark

 

[John W. Vinson]

I'm trying to display the bound value (which is binding correctly). this is
not how a combo box works... (correct?)

No; the displayed field will be the first nonzero width field in the Rowsource
query. There's no conflict with that also being the bound column.

You CANNOT include a memo field in a combo box without truncating it, though.
If you need the combo to select a record containing a memo field you'll need
to use some other method (such as DLookUp or a popup form) to display the full
text of the memo field.