Subform in Datasheet View display only one column

[vb9063]

Hi Guys,
I have a subform within a page of a form. I would like it to display as a datasheet type view so that it can be edited. I am using the form and its pages as a place to change the choices for my drop down menus.
I have made the subform show in datasheet view but I would like it to only display the one column and also to display it without the heading of the column as this column is named in the page name.
Any ideas??
Thanks!
VB

 

[Trevor G]

Hi Guys,
I have a subform within a page of a form. I would like it to display as a datasheet type view so that it can be edited. I am using the form and its pages as a place to change the choices for my drop down menus.
I have made the subform show in datasheet view but I would like it to only display the one column and also to display it without the heading of the column as this column is named in the page name.
Any ideas??
Thanks!
VB

You can place all the extra fields in the form header of the subform and the label of the field in the header as well, then open the properties of the header and change the visibility to No.

That should work for you.

 

[vb9063]

Thanks Trevor, it didnt seem to work, it showed the actual name instead of the label name...thanks
VB