A fourth option is to add a label control to each bound control (in form
view). The label caption is then displayed as the field header in datasheet
view.
- Steve
"Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message
news:4331777d$0$11759$5a62ac22@per-qv1-newsreader-01.iinet.net.au...[color=blue]
> 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[/color]
Field[color=blue]
> row in query design view, type whatever name you want in front of the[/color]
field[color=blue]
> 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[/color]
as[color=blue]
> 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." <g45340@hotmail.com> wrote in message
> news:43317514$0$15567$afc38c87@news.optusnet.com.a u...[color=green]
> >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[/color]
>
>[/color]
