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

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

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