Naming a datasheet form column heading

[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)

 

[Wayne Morgan]

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.

 

[Wayne Morgan]

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.

 

[Hugh O'Neill]

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)

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