Table column headings

[RichUE]

I have a table tbl_Structures. In Design View, I have added field
descriptions to all my fields. For example, the field txt_PartNum has a
description Part Number. I want Part Number to show in the column heading in
Datasheet View, but I get txt_PartNum.

I tried entering a Caption and this showed in the Column heading, but how
can I use the Description instead?

 

[Al Campagna]

RichUE,
Create a query against the table with all the fields.
Using the query design grid, in the txt_PartNum column...
Part Number : txt_PartNum
When you run the query, the txt_PartNum column will be titled "Part
Number"
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[RichUE]

Ah, I see. This sets the column heading in the query result. I must remember
that for later when I'm querying the data I'm going to collect. Thanks.
--
Richard

Search the web and raise money for charity at www.everyclick.com

RichUE,
Create a query against the table with all the fields.
Using the query design grid, in the txt_PartNum column...
Part Number : txt_PartNum
When you run the query, the txt_PartNum column will be titled "Part
Number"
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Al Campagna]

I think Access 2007 has the ability to accept column headings, different
than the field name.
I believe... in table design and query design... but don't quote me on that.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

Ah, I see. This sets the column heading in the query result. I must
remember
that for later when I'm querying the data I'm going to collect. Thanks.