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
|
|||
|
|||
Access 2002 - Grow to Fit Text in Database
I would like the cells (fields) in my database to
accommodate a greater amount of text when necessary - even to be able to tab to a second line in the cells (fields) if possible. I am using Microsoft Access 2002. Any suggestions would be greatly appreciated. |
#2
|
|||
|
|||
Your fields will allow as much data as you define for the field type. A
memo field will allow thousnads of characters. A text field will allow up to 255 characters. You can use multiple lines (especially in a memo field) without tabbing in your reports or forms. You should not be entering data directly into the table, if that is what you are doing. Rick B "Cathy" wrote in message ... I would like the cells (fields) in my database to accommodate a greater amount of text when necessary - even to be able to tab to a second line in the cells (fields) if possible. I am using Microsoft Access 2002. Any suggestions would be greatly appreciated. |
#3
|
|||
|
|||
Rick, I am entering data into the database view (I guess
it's the database view of the table.) I'm confused, Rick....where should I be entering data?....If I set up a field for 255 characters, it will type 255 characters, but on one line only - not multiple lines. Thanks for any help you can give me. -----Original Message----- Your fields will allow as much data as you define for the field type. A memo field will allow thousnads of characters. A text field will allow up to 255 characters. You can use multiple lines (especially in a memo field) without tabbing in your reports or forms. You should not be entering data directly into the table, if that is what you are doing. Rick B "Cathy" wrote in message ... I would like the cells (fields) in my database to accommodate a greater amount of text when necessary - even to be able to tab to a second line in the cells (fields) if possible. I am using Microsoft Access 2002. Any suggestions would be greatly appreciated. . |
#4
|
|||
|
|||
You need to build a form and make it look the way you want. build an input
form. When you add the fields to the form, you can shape them any way you want. Instead of making one wide field, you can make it a rectangle that allows several lines to be seen. This will also let you add vertical scroll bars. Build and work in your forms, not your table. Rick B "Cathy" wrote in message ... Rick, I am entering data into the database view (I guess it's the database view of the table.) I'm confused, Rick....where should I be entering data?....If I set up a field for 255 characters, it will type 255 characters, but on one line only - not multiple lines. Thanks for any help you can give me. -----Original Message----- Your fields will allow as much data as you define for the field type. A memo field will allow thousnads of characters. A text field will allow up to 255 characters. You can use multiple lines (especially in a memo field) without tabbing in your reports or forms. You should not be entering data directly into the table, if that is what you are doing. Rick B "Cathy" wrote in message ... I would like the cells (fields) in my database to accommodate a greater amount of text when necessary - even to be able to tab to a second line in the cells (fields) if possible. I am using Microsoft Access 2002. Any suggestions would be greatly appreciated. . |
#5
|
|||
|
|||
For an example, open the sample database "Northwinds" that comes with
Access. look at the various forms used for data entry, Rick B "Cathy" wrote in message ... Rick, I am entering data into the database view (I guess it's the database view of the table.) I'm confused, Rick....where should I be entering data?....If I set up a field for 255 characters, it will type 255 characters, but on one line only - not multiple lines. Thanks for any help you can give me. -----Original Message----- Your fields will allow as much data as you define for the field type. A memo field will allow thousnads of characters. A text field will allow up to 255 characters. You can use multiple lines (especially in a memo field) without tabbing in your reports or forms. You should not be entering data directly into the table, if that is what you are doing. Rick B "Cathy" wrote in message ... I would like the cells (fields) in my database to accommodate a greater amount of text when necessary - even to be able to tab to a second line in the cells (fields) if possible. I am using Microsoft Access 2002. Any suggestions would be greatly appreciated. . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Change font of part of text | John | Powerpoint | 7 | March 15th, 2005 10:10 AM |
Help with design | Ronnie | Database Design | 6 | March 12th, 2005 02:53 PM |
Outline | Renee Hendershott | Page Layout | 2 | December 25th, 2004 02:49 PM |
Access 2000 -vs- Access 2003? | Mark | General Discussion | 5 | November 30th, 2004 06:36 AM |
You do not have exclusive access... ERROR | Robin | General Discussion | 1 | July 6th, 2004 01:18 AM |