A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old October 12th, 2004, 10:25 PM
accessless
external usenet poster
 
Posts: n/a
Default 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  
Old October 12th, 2004, 10:33 PM
Wayne Morgan
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 09:17 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.