Access 2007 Field Names (2 lines)

J

jdr

Can anyone tell me how I can make my field name box 2 lines. Instead of the
column title/field name being Customer ID all on one line, my professor wants
Customer with ID right under at the top of the column.
 
K

KARL DEWEY

In design view click on the label and drag the bottom down and then the side
to narrow it.
You also might want to click on menu VIEW - Properties and then scroll down
to Text Align property and set for Center.
 
P

Paul Shapiro

Is this in a label, or in the table design mode? If it's a label, use
<Ctrl><Enter> to force a new line.
 
J

jdr

Thanks for the response but I cannot manipulate the field names cells (column
titles) from any view. I can change the width of the entire column but then
I loose part of the column title instead of it moving to the next line. The
data that is typed into each column will move to the second line, but not the
titles.
 
G

Gina Whipp

JDR,

If you are trying to do this is the Column Titles in a datasheet then you
are correct you cannot do that there. It can be done in labels and in
fields, other than that you would have to change the Column Width.
 
J

John W. Vinson

Thanks but while this works for the data entered into the columns Access 2007
will not allow me to use <Ctrl><Enter> in the field name (column titles). I
get an error telling me that I cannot use certain keys. It works for the
data entered into the columns but not for the field names (column titles).
Click to expand...

Well, tables are NOT designed or intended for data presentation - use a
continous Report with labels instead, if you need this appearance!

It sounds like your professor is being a bit snarky. There may be some
underhanded way to do this - such as explicitly setting the fieldname to
SomeText & Chr(13) & Chr(10) & SecondLineOfText in VBA code - but it would not
be something one would ever want to do in a working database!
 
J

jdr

Thanks. I've been going nuts trying to find out how to do this for 2 days
now, searching internet, textbooks, everything, try it - test it
stuff.......but no way I could get it to two lines. And since she wants to
see two tables that I have to create a relationship between I don't think I
could do the continuous report.
 
J

jdr

Thanks. I'm going to stop driving myself crazy trying to figure out how to
do this since it cannot be done.
 
J

John W. Vinson

Thanks. I've been going nuts trying to find out how to do this for 2 days
now, searching internet, textbooks, everything, try it - test it
stuff.......but no way I could get it to two lines. And since she wants to
see two tables that I have to create a relationship between I don't think I
could do the continuous report.
Click to expand...

ummm... sure you can. Base it on a Query joining the tables. Or am I missing
something???
 
Top