Query Based Column heading

J

Jologs

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.
 
K

Ken Snell [MVP]

Did you remember to change the ControlSource of your controls to be the new
'alias' names?
 
D

Dirk Goldgar

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.
 
Top