Hi Folks - I'd like to display a list of records in datasheet view. One of 
the fields is a checkbox. I'd like users to select the records to print, 
then click a command button that runs a report. I thought a form in 
datasheet view with a command button in the form header would easily 
accomplish this task. However, it looks like a form in datasheet view cannot 
display a command button. Do you have any workarounds? Thanks.

Michael

Change Datasheet to Continuous Forms. Put the field labels in the form header
above the field's textbox, put all textboxes at the top of the detail section,
make all textboxes the same height, change the height of the detail section
to the height of the textboxes. BAM, you're done! Gives the appearance of
datasheet, but allows use of form header/footer.





Michael wrote:
>Hi Folks - I'd like to display a list of records in datasheet view. One of 
>the fields is a checkbox. I'd like users to select the records to print, 
>then click a command button that runs a report. I thought a form in 
>datasheet view with a command button in the form header would easily 
>accomplish this task. However, it looks like a form in datasheet view cannot 
>display a command button. Do you have any workarounds? Thanks.
>
>Michael

-- 
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200710/1

Make your datasheet form a subform and put your command buttons on the main 
form.
-- 
Dave Hargis, Microsoft Access MVP


"Michael" wrote:

> Hi Folks - I'd like to display a list of records in datasheet view. One of 
> the fields is a checkbox. I'd like users to select the records to print, 
> then click a command button that runs a report. I thought a form in 
> datasheet view with a command button in the form header would easily 
> accomplish this task. However, it looks like a form in datasheet view cannot 
> display a command button. Do you have any workarounds? Thanks.
> 
> Michael
> 
> 
> 
> 

Awesome .... Thanks.



"benyod79 via AccessMonster.com" <u23098@uwe> wrote in message 
news:7a38f438a3447@uwe...
> Change Datasheet to Continuous Forms. Put the field labels in the form 
> header
> above the field's textbox, put all textboxes at the top of the detail 
> section,
> make all textboxes the same height, change the height of the detail 
> section
> to the height of the textboxes. BAM, you're done! Gives the appearance of
> datasheet, but allows use of form header/footer.
>
>
>
>
>
> Michael wrote:
>>Hi Folks - I'd like to display a list of records in datasheet view. One of
>>the fields is a checkbox. I'd like users to select the records to print,
>>then click a command button that runs a report. I thought a form in
>>datasheet view with a command button in the form header would easily
>>accomplish this task. However, it looks like a form in datasheet view 
>>cannot
>>display a command button. Do you have any workarounds? Thanks.
>>
>>Michael
>
> -- 
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200710/1
>