Query Based Column heading

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi:

I have a subform in Datasheet view that is based on a query. What should I
do to customize the column heading of the subform.

I tried to put aliases on the query but it retuns #name to my subform.
Please help.
 
Did you remember to change the ControlSource of your controls to be the new
'alias' names?
 
Jologs said:
Hi:

I have a subform in Datasheet view that is based on a query. What
should I do to customize the column heading of the subform.

I tried to put aliases on the query but it retuns #name to my subform.
Please help.
Click to expand...

For a form in datasheet view, the column headers will be taken from the
labels attached to the controls in design view. If a control has no
attached label, then the column header will be taken from the name of
the control.
 
Back
Top