Add Controls to DataSheet Form

[RC-]

Hi, is there a way that I can add controls to a DataSheet form? I know that
you can right click for controls, but i would like to put controls on the
botton of the form so that non Access users will have a clear understanding
of what to do.

TIA
RC-

 

[Larry Linson]

Hi, is there a way that I can add controls to
a DataSheet form? I know that you can right
click for controls, but i would like to put
controls on the botton of the form so that
non Access users will have a clear understanding
of what to do.

Datasheet View is not a Form, and doesn't support Controls. Why don't you
create a Form? If you want to present the data in Rows and Columns, that's
easy with "continuous forms view." In either a Single Form view, or
Continuous Forms View, you can optionally show a Header and Footer into
which you can place controls, as well as placing them on each row of data.

Larry Linson
Microsoft Access MVP

 

[Bill Mosca, MS Access MVP]

Datasheets are pretty stripped down. You can use a continuous form or put
the datasheet in as a sub form on a mani form.

 

[John Nurick]

Instead, use a continuous form laid out to look like the datasheet. You
can then put any other things you need on the form's header and footer.

 

[RC-]

Oh, OK, I see now. I didn't know about the "Continous Forms" view. I like
it.

Thanks Larry!
RC-

 

[RC-]

Thanks all, I have done what you all suggested and my boss loves it!!

Thanks,
RC-