Change Query column labels?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The column labels (headings) naturally reflect the field names.
How can I edit these as in some cases they are longer (wider) than is
necessary for the data to be displayed, making the columns wider than they
need be and causing the query to fall off the right side of the screen, so it
has to be scrolled. And in some cases they are not "plain English" therefore
not ideal for the typical Management user.
How can I replace these with whatever I want?
Many thanks
CW
 
In query design view, type the label you want in front of the field,
followed by a colon.

Example:
City: [WhateverYourLongFieldNameIsForTheCityHere]
 
Perfect! Thanks so much, Allen.
CW

Allen Browne said:
In query design view, type the label you want in front of the field,
followed by a colon.

Example:
City: [WhateverYourLongFieldNameIsForTheCityHere]

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

CW said:
The column labels (headings) naturally reflect the field names.
How can I edit these as in some cases they are longer (wider) than is
necessary for the data to be displayed, making the columns wider than they
need be and causing the query to fall off the right side of the screen, so
it
has to be scrolled. And in some cases they are not "plain English"
therefore
not ideal for the typical Management user.
How can I replace these with whatever I want?
Many thanks
CW
Click to expand...
Click to expand...
 
Back
Top