Command buttons on a datasheet form?

J

Jarda Beran

Hi,
is there a way how to add command buttons on datasheet form? I need to
enable users print a specific report from a datasheet form, but there is no
space to add command button to.
Thanks for any advice
 
A

Allen Browne

No, you can't use command buttons on a form in Datasheet view.

Use Continuous form view instead. You can arrange the text boxes side by
side, and place their labels above them in the Form Header section.
 
M

Maurice

In datasheet view it is not possible to add buttons. What you can try is
place the trigger to open the report on the double click event of a certain
field. That will work. If you prefer the button than create the datasheet
form as a subform in a dummy form and place the button on the dummyform and
fire the report open action from there.

hth
 
Top