Two-line fields

[cawhitaker]

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!

 

[Jeff Boyce]

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.

 

[Fred]

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.

 

[cawhitaker]

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?

 

[fredg]

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.

 

[Scott_Brasted via AccessMonster.com]

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

 

[Jeff Boyce]

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.