How to set an Access text box with multiple lines available to pre

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

Guest

I'm trying to use a textbox to display a list of items. First, I could not
arrow (or use Enter) to move down within the cell of a table. It would only
show a list of items if I entered data into the form first. So, I went in and
changed the properties of the text box in the form to: On the events tab, IME
Sentence Mode to Prase Predict and Enter Key Behavior to New Line in Field.
It worked for a minute (or so it seemed), but now I'm back to the original
problem. Only, the properties now have the changed values as I selected.
Help! I want to be able to show/add a list of items within the cell of the
table.
 
For starters, it appears you may have a problem with the construction of
your database. There shouldn't normally be a "list of items" in a table's
cell. If you need to link multiple items to a record, you need to create
another table, enter each of the items in multiple records in the other
table, one of the fields in the other table will be the Unique ID field of
the record you are trying to link the multiple items to. You would then
retrieve the multiple items by using a query to "search" the other table
based on the Unique ID of the record you are linking to. You could then use
a List Box control or a Subform to display the multiple items.
 
Back
Top