Record selector turn off

[Lee]

Does anyone know how to hide the record selectors when a form is in
datasheet view?

Thanks

Lee

 

[Dirk Goldgar]

Does anyone know how to hide the record selectors when a form is in
datasheet view?

I don't believe you can. Datasheet view is what it is. You could
display the form in continuous forms view instead, and format it to look
like datasheet view.

 

[Lee]

Yeah that is what I was afraid of too.

I can't use the continuous forms because I have nested subforms. I am using
the ability of the datasheets to expand the sub forms using the + (basicly
a tree view)

Ah well, it is what is it is.

 

[Guest]

Why you want to do that?
The only reason I could think that you would like to do that is that the
user wont be able to delete a record, if that the case then put the "can
delete" on the form property to false

 

[Dirk Goldgar]

Yeah that is what I was afraid of too.

I can't use the continuous forms because I have nested subforms. I
am using the ability of the datasheets to expand the sub forms using
the + (basicly a tree view)

Ah well, it is what is it is.

Maybe you could use the TreeView ActiveX control, but it would make you
do a lot of the work yourself. I've never used it.

 

[Lee]

That is about the only way I though of also but I don't want to have to send
any other controls along with this. I'm happy with how I have the
datasheets functioning, just wanted to make it look a little nicer.

Thanks

Lee

 

[Albert D. Kallal]

You could use two sub forms. on the left side you display the records, and
on the right side you display the details for the left record?

I do this all the time...you can see some screen shots here:

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm