Dropdown List Box-Memo List

[trident]

I created a drop down list box where the following are stated:

Brand - Text
Model - Text
Description - Memo

The information save on another table is only the model, the Brand should only appear on screen or printed as well as for the description.
the form shows a follow:



Model - Dropdown List Box
Brand - =Model.column (1)
Description - =model.column(2)

my problem is that the description is not showing in the Dropdown, for this to populate the description.
I have seen some explanations that a MEMO cannot be included in the Dropdown List Box.

How can I include the description to the form or in a report.

Hope you can help me.

Trident

[ranman256]

Don't use memo.
the query that controls the combo should have 2 columns; prod,descr.
the combo box property COLUMNS=2
COLUMNWIDTHS=1;3. (Or adjust to your text lengths)

[trident]

Dear Ranman256,

The problem here is that the Description which is a MEMO type is arranged as how it will look like when it is printed.

is there any other way to show the memo in the form even if it does not appear in the Drop Down List Box?

How can I call the Description from another table by used unbound text box.

Again, thank you for your assistance.

Trident

[Missinglinq]

It's not that you can't use a Memo Field in a Combobox...it's just that they will always be truncated to the first 265 characters of the Field! Instead, you need to use the DLookup function, using Criteria to tell the Access Gnomes which Record to pull this data from:

Where the First Field/Column in the Combobox is

• A Unique Identifying Field for the Record (such as an ID Number)
• The Bound Field for the Combobox

and where

• UniqueIdentifier is the name of the Field in the Table

' If the UniqueIdentifier is Text

Private Sub ComboBoxName_AfterUpdate(Cancel As Integer)
  Me.MemoFieldTextBox = DLookup("MemoFieldName", "TableName", "[UniqueIdentifier]= '" & Me.ComboBoxName & "'")
End Sub

' If the UniqueIdentifier is Numeric

Private Sub ComboBoxName_AfterUpdate(Cancel As Integer)
  Me.MemoFieldTextBox = DLookup("MemoFieldName", "TableName", "[UniqueIdentifier]= " & Me.ComboBoxName)
End Sub

Replacing MemoFieldTextBox with the actual name of your description Textbox. This assumes that the Bound Column of the Combobox is the UniqueIdentifier...which I believe, from your post is 'Model.'

Linq ;0)>