How do I enter a Database Field Name on two lines?

[Database Field Name]

How do I enter a Field Name (Column Title) on two seperate lines on a Data
Table? For example, I want to name the Field "Customer Number" with
"Customer" on the top line and "Number" on a second line underneath Customer.
This would substantially reduce the column size required.

 

[KARL DEWEY]

You can not do it in a table but in a form or report.
In design view of the form or report just click the label and drag to the
shape you want.

 

[Jeff Boyce]

As Karl points out, this is something you'd use a form to do. Access tables
store data, Access forms (and reports) display data.

You (and your application's users) are better off using forms than working
directly in the tables.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Tony Toews [MVP]]

How do I enter a Field Name (Column Title) on two seperate lines on a Data
Table? For example, I want to name the Field "Customer Number" with
"Customer" on the top line and "Number" on a second line underneath Customer.
This would substantially reduce the column size required.

In addition to using forms as suggested I use the Caption for this.
My field names never, ever have spaces in them but I put the human
friendly portion in the caption. Then, as stated, on forms I will
shorten the width of the label and make it taller.

Tony's Object Naming Conventions
http://www.granite.ab.ca/access/tonysobjectnamingconventions.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/