multi line combo boxes

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

Guest

In Access 2003 I have created a combo box that is linked to a memo field (the
data in the field is just an id number but a memo is visible). After I make
the selecton, the whole memo is visible in the combo box (which is good), but
while I making the selection the combo box only shows one line for each
option (as wide as the combo box). How do I make the entie memo visible in
order to select one of them? I hope this makes sense.
 
bumpmobile said:
In Access 2003 I have created a combo box that is linked to a memo
field (the data in the field is just an id number but a memo is
visible). After I make the selecton, the whole memo is visible in
the combo box (which is good), but while I making the selection the
combo box only shows one line for each option (as wide as the combo
box). How do I make the entie memo visible in order to select one of
them? I hope this makes sense.
Click to expand...

You can't. And if you investigate further you will find that even after making
the selection you are only getting the first 255 characters from your memo
field, not the entire thing. ListBoxes and ComboBoxes cannot display more than
this.

You can use DLookup() to retrieve the full Memo field into another TextBox after
making your selection.
 
I was afraid of that (I didn;t notice that it only allowd 255 characters
until after my last post). Witht that said, does anyone have any suggestions
as to how I can give users the ability to chose from a number of different
memos?
 
bumpmobile said:
I was afraid of that (I didn;t notice that it only allowd 255
characters until after my last post). Witht that said, does anyone
have any suggestions as to how I can give users the ability to chose
from a number of different memos?
Click to expand...

As I stated in my first reply you can have the ComboBox with the Primary Key and
enough of the memo for the user to make a choice and then use DLookup() to
retrieve the entire memo into a TextBox using the PK found in the ComboBox for
criteria.
 
Back
Top