Header in form view won't show datasheet records

[Guest]

I would like to have a form with the header band that contains various custom
action buttons and the detail band of the form containing a datsheet view of
table records.

Problems :
1) Using the above layout and setting the overall form Default View property
to "datasheet" omits the header. I can see only the detail datasheet. Can the
Header be prevented from disappearing in datasheet view?

2) Using the above layout BUT setting the datasheet into a subform dropped
in the detail section of the main form allowed the header to remain visible
since the form Default View is now set to Single form, but the field headers
from the datasheet are lost! Arghhhhhh ! Can I get field headers visible?

Your assistance is appreciated.

Regards

Rob G
Brisbane (Fine and 30deg c)

 

[Arvin Meyer [MVP]]

You do not loose the column headers when you add a datasheet to the detail
section of a single form.

You can solve both of your problems by using a continuous form instead of a
datasheet. While I personally prefer the additional design options available
in a continuous form, you can make one look exactly like a datasheet if you
prefer that look. With a continuous form, add the row of column header
labels to the form header, and above that row of labels you can add all the
buttons you wish. If you want to sort on your column header labels, use
their click event to do the sorting, or change them to either a command
button or toggle button to do the sorting.

 

[Brendan Reynolds]

When you say 'field headers', do you perhaps mean that you are seeing the
field names rather than the labels' captions? If so, the issue is that the
labels are not associated with the other controls (textboxes, comboboxes,
etc). You can fix this by selecting the label, cutting it to the clipboard
(Ctrl+X), then selecting the textbox, combobox or whatever you want the
label associated with, and pasting the label (Ctrl+V). The label will then
be associated with the selected control, and the caption of the label will
be used as the column heading in datasheet view.