Two-line fields
in [Tables]
|
Prev: one to many or many to one
Next: Access Database
From: cawhitaker on 17 Nov 2009 13:45 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!
From: Jeff Boyce on 17 Nov 2009 14:07 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" <cawhitaker(a)discussions.microsoft.com> wrote in message news:3D75AD77-AA98-4AC7-A9FB-4310C9E5B711(a)microsoft.com... >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!
From: Fred on 17 Nov 2009 14:22 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.
From: cawhitaker on 17 Nov 2009 14:30 "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?
From: fredg on 17 Nov 2009 17:24
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 |