Datasheet View in Form

  • Thread starter Thread starter Conner Stevens
  • Start date Start date
C

Conner Stevens

I have a subform that is in datasheet view. I notice that when I go to
design view there is a header and footer and there are text descriptions
above each field. When I go to form view, I only get the "spreadsheet" look
with the actual field names as the column headers. Is there any way to
change this?

Thanks,

CS
 
A datasheet form in design view loks like a regular form
in design view. Include the controls from your datasource
that you wish to appear and change the label names to what
you wnat to appear in the field headers.
 
Datasheets will use the caption of an _attached_ label, if there is one. If
not, it will use the name of the textbox.

Since the labels are in the header, they are not attached to the textboxes.
You can select each label, and use Ctrl-x to cut it, select the textbox you
want associated with it, and use ctrl-v to paste it. It will now be
attached to the textbox, and datasheet view will use the label caption.

If you have a large number of controls, and little code behind the subform,
you may find it easier to delete the subform and recreate it.

Choose AutoForm-Columnar. Then open the form in design view and change the
form's 'default view' and 'views allowed' to datasheet.
 
Back
Top