A very simple option is to display your subform in Continuous Form view
instead of Datasheet view. You can put whatever you like into the Form
Header section of the form, and show that over the field.
Another option is to use a query as the source for your field. In the Field
row in query design view, type whatever name you want in front of the field
name, followed by a colon, e.g.:
Customer Name: CustN
Then use this as the RecordSource for your form.
A third option is to use the Caption property of the field in the table.
1. Open the form in design view.
2. Select the CustN field.
3. In the lower pane, beside the Caption property, enter:
Customer Name
You have not changed the field name, but Access will use this as the
heading. Some peope find this confusing, that the heading is not the same as
the field name throughout Access.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Gary T." <g4****@hotmail.com> wrote in message
news:43***********************@news.optusnet.com.a u...
I have a subform (that is linked to a table) in a blank form.
When the table is viewed in its subform state in the form, the headings
are
not user friendly.
ie. CustN
I would want it to read in the subform heading column as Customer Name
without affecting the actually field heading in the table itself..... if
that makes sense.
Any suggestions?
thanks