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
|
|||
|
|||
Two-line fields
I want to put one of the field names in my database on two lines. Is this
possible? Example: Client Address City Zip Name I know I can do this in Excel, but would like to do it in Access. Thanks! |
#2
|
|||
|
|||
Two-line fields
While you haven't explicitly said so, I'm guessing you are trying to do this
directly on the table. An Access table is NOT an Excel spreadsheet. If you try to treat it like a spreadsheet, both you and Access will end up working overtime ... you wouldn't expect a chainsaw to work like a hammer, would you? Access tables store data. Access forms display data. What you are trying to do is 'piece-of-cake' simple ... in a form! Use the forms, Luke! Good luck Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "cawhitaker" wrote in message ... I want to put one of the field names in my database on two lines. Is this possible? Example: Client Address City Zip Name I know I can do this in Excel, but would like to do it in Access. Thanks! |
#3
|
|||
|
|||
Two-line fields
In databases, the data (including field names) is a seperate issue from the
display of it. You could create hundreds of different displays of your field names in reports, forms queries tables, with forms and reports. Forms and reports are the most common ways to display such, and, in those, you can format the heaings any way that you want including 2 lines. |
#4
|
|||
|
|||
Two-line fields
"Fred" wrote: In databases, the data (including field names) is a seperate issue from the display of it. You could create hundreds of different displays of your field names in reports, forms queries tables, with forms and reports. Forms and reports are the most common ways to display such, and, in those, you can format the heaings any way that you want including 2 lines. I can't get the field heading to show on two lines in a table without doing a form or a report. Can I show the field heading on two lines in a table? |
#5
|
|||
|
|||
Two-line fields
On Tue, 17 Nov 2009 11:30:03 -0800, cawhitaker wrote:
"Fred" wrote: In databases, the data (including field names) is a seperate issue from the display of it. You could create hundreds of different displays of your field names in reports, forms queries tables, with forms and reports. Forms and reports are the most common ways to display such, and, in those, you can format the heaings any way that you want including 2 lines. I can't get the field heading to show on two lines in a table without doing a form or a report. Can I show the field heading on two lines in a table? You cannot format a field name or the field's caption (in a table, or in Form Datasheet View) to display multiple lines. Listen to what the other two guys have told you. Use a Form (in Single View or Continuous View) to display table data, not the table. Tables are for storing data, not for viewing. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#6
|
|||
|
|||
Two-line fields
Good afternoon,
You are in the same position I ws in a long time ago. It is not a very nice place to be. You need to think completely differently than you are right now. You need a basic understanding of databses and Access. Here is a link to a site that can help get you started. But I warn you, take NO preconceived notions with you. As a previous poster said, Access is NOT Excel. links: http://allenbrowne.com/tips.html#Beginner http://allenbrowne.com/casu-01.html Use this resource. Allen Browne has forgotten more than I will ever know. But mostly, please listen to the advice you request. No here will mislead you. Good Luck to you. Best, Scott cawhitaker wrote: In databases, the data (including field names) is a seperate issue from the display of it. You could create hundreds of different displays of your field names in reports, forms queries tables, with forms and reports. Forms and reports are the most common ways to display such, and, in those, you can format the heaings any way that you want including 2 lines. I can't get the field heading to show on two lines in a table without doing a form or a report. Can I show the field heading on two lines in a table? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200911/1 |
#7
|
|||
|
|||
Two-line fields
Scott
I'll disagree only with one point you made ... Since the folks here are volunteering their observations, and since folks have differing levels of skills and experience (and motivation), I suspect it IS possible to get misled here... Take anything you receive with a grain of salt... or three. Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Scott_Brasted via AccessMonster.com" u56211@uwe wrote in message news:9f5d2fa1ae388@uwe... Good afternoon, You are in the same position I ws in a long time ago. It is not a very nice place to be. You need to think completely differently than you are right now. You need a basic understanding of databses and Access. Here is a link to a site that can help get you started. But I warn you, take NO preconceived notions with you. As a previous poster said, Access is NOT Excel. links: http://allenbrowne.com/tips.html#Beginner http://allenbrowne.com/casu-01.html Use this resource. Allen Browne has forgotten more than I will ever know. But mostly, please listen to the advice you request. No here will mislead you. Good Luck to you. Best, Scott cawhitaker wrote: In databases, the data (including field names) is a seperate issue from the display of it. You could create hundreds of different displays of your field names in reports, forms queries tables, with forms and reports. Forms and reports are the most common ways to display such, and, in those, you can format the heaings any way that you want including 2 lines. I can't get the field heading to show on two lines in a table without doing a form or a report. Can I show the field heading on two lines in a table? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200911/1 |
Thread Tools | |
Display Modes | |
|
|