If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to set an Access text box with multiple lines available to pre
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. |
#2
|
|||
|
|||
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. -- Wayne Morgan MS Access MVP "accessless" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Lines on a report growing with a text box set to CanGrow | lisa | Setting Up & Running Reports | 1 | September 23rd, 2004 10:43 PM |
Merging with Access queries - Multiple | CPutnam | Mailmerge | 5 | August 21st, 2004 01:11 PM |
scrolling programmatically? | alekm | New Users | 1 | July 6th, 2004 02:56 AM |
insert text in arrow lines problem | Matt | New Users | 4 | May 26th, 2004 06:56 AM |
Vertical Text Orientation | Paul Anderson [MSFT] | Visio | 0 | May 11th, 2004 05:16 PM |