J
Joe Miller
I would like to format a subform which I want, for very specific reasons, to
be in datasheet view only. The formatting issues I have with the datsheet
view are these:
1) The big grey void that appears to the right of the last field and the
bottom of the last record - can the form be formatted in such a way that this
does not appear?
2) I want to get rid of the record selector on the left hand side of the
form (furthermore, can the form be fomatted in such a way that a single click
on any of the fields in any of the records will 'select' and highlight the
entire record in such a way that the user can see that they have highlighted
it and that data from the record can be passed to a VBA proceedure which will
fire, for example, when a command button on the main form is clicked?)
3) Can you change the background/ font colour of the field headings in
datasheet view?
Thanks
Joe Miller
be in datasheet view only. The formatting issues I have with the datsheet
view are these:
1) The big grey void that appears to the right of the last field and the
bottom of the last record - can the form be formatted in such a way that this
does not appear?
2) I want to get rid of the record selector on the left hand side of the
form (furthermore, can the form be fomatted in such a way that a single click
on any of the fields in any of the records will 'select' and highlight the
entire record in such a way that the user can see that they have highlighted
it and that data from the record can be passed to a VBA proceedure which will
fire, for example, when a command button on the main form is clicked?)
3) Can you change the background/ font colour of the field headings in
datasheet view?
Thanks
Joe Miller