Datasheet View in Form

[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

[Bish]

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.

>-----Original Message-----
>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
>
>
>.
>

[Joan Wild]

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.

--
Joan Wild
Microsoft Access MVP

"Conner Stevens" <cstevens@heavymonkey.com> wrote in message
news:viiug16n2som99@corp.supernews.com...

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