Naming a datasheet form column heading

  • Thread starter Thread starter John Baker
  • Start date Start date
J

John Baker

Is there anyway to have the name on a datasheet form column heading to be
that of the contents of a textbox on a form?
Or is there anyway to change the column heading at run time?


Any help greatly appreciated.

John Baker
(e-mail address removed)
 
The column heading on a form in datasheet view comes from one of two places.

It will come from the label ATTACHED to the control. If the label has become detached from
the control, the name comes from the name of the control.

You can move the label and control separately, but if you delete the label or move it to a
different section of the form it will be come detached.

To create a new label that is attached to the control:

1) Create a new label or use the old one if you still have it
2) Cut (Ctrl+X) the label
3) Select the control
4) Paste (Ctrl+V) the label

The label should show up next to the control and once again be attached to it.
 
The column heading on a form in datasheet view comes from one of two places.

It will come from the label ATTACHED to the control. If the label has become detached from
the control, the name comes from the name of the control.

You can move the label and control separately, but if you delete the label or move it to a
different section of the form it will be come detached.

To create a new label that is attached to the control:

1) Create a new label or use the old one if you still have it
2) Cut (Ctrl+X) the label
3) Select the control
4) Paste (Ctrl+V) the label

The label should show up next to the control and once again be attached to it.
 
John said:
Is there anyway to have the name on a datasheet form column heading
to be that of the contents of a textbox on a form?
Or is there anyway to change the column heading at run time?


Any help greatly appreciated.

John Baker
(e-mail address removed)
Click to expand...


You may we better off using a continuous Form rather than datasheet
Form. You have much better control over it and what your users are
allowed to do. And you can make it look like the datasheet style if
you really want to.

hth

Hugh
 
Back
Top