Access Datasheet Forms and Command Button

[lewis33]

Hi, I have a couple of, I hope, not too complex questions.
1. Everytime I close the datasheet view now, the form returns to my original main form but it does not fill the entire available window. I don't need any scroll bars or min/max buttons and I've disable them but it still does not expand to cover up the entire available opening under the tool bars


2. With this database, I want to have the users open up the data via a datasheet form. Is it possible to add a command button to this type of form-don't suspect that it is. Not too important but I thought it would look better than the standard min/max buttons.

Thanks everyone---

 

[hymn]

1./ In the On Current event of the form
docmd.maximise

2./ What version Of Access 2000 plus use Conditional Formatting

Hope this helps
Hymn

 

[lewis33]

Thank you. I'm using Access 2002. I added in the event proceduere and that works fine except that now I lose the close buttons even though I have them enabled on the properties sheet. I have to use the min/max buttons in order to see them.