|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
|
|
#1
January 13th, 2009, 04:47 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Table column headings
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? -- Richard Using MS Access 97 Search the web and raise money for charity at www.everyclick.com 
|
|
#2
January 13th, 2009, 06:43 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Table column headings
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" wrote in message news  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? -- Richard Using MS Access 97 Search the web and raise money for charity at www.everyclick.com
|
|
#3
January 14th, 2009, 09:03 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Table column headings
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 "Al Campagna" wrote: 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" wrote in message news 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? -- Richard Using MS Access 97 Search the web and raise money for charity at www.everyclick.com
|
|
#4
January 15th, 2009, 03:08 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Table column headings
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." "RichUE" wrote in message ... 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 "Al Campagna" wrote: 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" wrote in message news 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? -- Richard Using MS Access 97 Search the web and raise money for charity at www.everyclick.com
|
| Thread Tools | |
| Display Modes | |
|
|
Hybrid Mode
