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

  • Thread starter Thread starter Database Field Name
  • Start date Start date
D

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.
 
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.
 
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
 
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.
Click to expand...

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/
 
Back
Top