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
|
|||
|
|||
Row Header Captions
I have half dozen or so tables related many to one to a master table. Many
of these tables share field name such as: Quantity, Value, Category, etc. (and yes, each table is a unique entity within the db.) In order to maintain a unique identity for each field I place a prefix before each field name; which generally is an abreviation of the table name. I then gave a caption to those field names reflecting their pre-prefix identity. The problem I have is when making a subform of these tables the prefix attached field name shows up in the row header and not the caption - which is absurd! Is there a way besides re-entering the captions in the properties dialog, to automatically have the caption as the row header on the form? TIA doco |
#2
|
|||
|
|||
Create a query, and add aliases for the appropriate fields. Use the query on
the form instead of the table. Regards, Graham R Seach Microsoft Access MVP Sydney, Australia --------------------------- "doco" wrote in message ... I have half dozen or so tables related many to one to a master table. Many of these tables share field name such as: Quantity, Value, Category, etc. (and yes, each table is a unique entity within the db.) In order to maintain a unique identity for each field I place a prefix before each field name; which generally is an abreviation of the table name. I then gave a caption to those field names reflecting their pre-prefix identity. The problem I have is when making a subform of these tables the prefix attached field name shows up in the row header and not the caption - which is absurd! Is there a way besides re-entering the captions in the properties dialog, to automatically have the caption as the row header on the form? TIA doco |
#3
|
|||
|
|||
Yes! Thanks...
doco "Graham R Seach" wrote in message ... Create a query, and add aliases for the appropriate fields. Use the query on the form instead of the table. Regards, Graham R Seach Microsoft Access MVP Sydney, Australia --------------------------- "doco" wrote in message ... I have half dozen or so tables related many to one to a master table. Many of these tables share field name such as: Quantity, Value, Category, etc. (and yes, each table is a unique entity within the db.) In order to maintain a unique identity for each field I place a prefix before each field name; which generally is an abreviation of the table name. I then gave a caption to those field names reflecting their pre-prefix identity. The problem I have is when making a subform of these tables the prefix attached field name shows up in the row header and not the caption - which is absurd! Is there a way besides re-entering the captions in the properties dialog, to automatically have the caption as the row header on the form? TIA doco |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Include "To:" Header in IMAP Download | Brett | Installation & Setup | 2 | July 1st, 2005 08:07 PM |
Report Header Template | [email protected] | Setting Up & Running Reports | 3 | January 28th, 2005 10:34 PM |
Supressing header on select pages only | SME | Formatting Long Documents | 4 | August 26th, 2004 01:32 PM |
Header formatting in LINKed docs not working | Dennis | Page Layout | 4 | July 5th, 2004 10:04 AM |
Mail Rules on Email Header | Stever | Outlook Express | 13 | June 26th, 2004 09:26 PM |