Datasheet question again

W

Wayne-I-M

Hi Phill

Don't think so.

You could create a form with a header and then place the datasheet within
this as a subform. This would give the same effect provideing you don't have
a border.
 
W

Wayne-I-M

Sorry Maurice and Joan - just noticed you had already answered this question.

Phile it's not really a good idea to ask the same question but with a
different header.
 
P

Phil Hunt

Sorry, did not mean to.


Wayne-I-M said:
Sorry Maurice and Joan - just noticed you had already answered this
question.

Phile it's not really a good idea to ask the same question but with a
different header.
Click to expand...
 
M

MacNut2004

Hello,

I have done this, inserting a datasheet as a subform on my main form.
Question is: How do you get it to be a datasheet view without having to
maximize but the width and height of hte subform itselff to show ALL the data?

Thanks,
MN
 
R

Rick Brandt

MacNut2004 said:
Hello,

I have done this, inserting a datasheet as a subform on my main form.
Question is: How do you get it to be a datasheet view without having
to maximize but the width and height of hte subform itselff to show
ALL the data?
Click to expand...

Make the subform control taller and wider? Sorry the question doesn't
really make much sense to me.
 
M

MacNut2004

Wel that is what I am having to do in order to show all the data in my
subform -- which i made to be a datasheet view. What i want is it to be a
true datasheet, where no matter what the "size' of the subform is on the main
form...that it will show ALL the data -- so you can scroll to the right to
see everything. That is not how it is working when it's a subform within a
form.
 
R

Rick Brandt

MacNut2004 said:
Wel that is what I am having to do in order to show all the data in my
subform -- which i made to be a datasheet view. What i want is it to
be a true datasheet, where no matter what the "size' of the subform
is on the main form...that it will show ALL the data -- so you can
scroll to the right to see everything. That is not how it is working
when it's a subform within a form.
Click to expand...

It is if you enable scrollbars. Look at the scrollbars property of the form
shown in the subform control. Not of the subform control.
 
R

Rick Brandt

MacNut2004 said:
scrollbars are enabled on both the subform and the form...
Click to expand...

I don't understand it then. If the form being shown within the subform
control has scrollbars enabled then you should see them when viewing the
main form.
 
M

MacNut2004

I SEE the scrollbars...but what i'm saying is that the subform -- which is
supposed to be viewd in datasheet view, is not being viewed that way within
the main form. I can't view ALL thte subform's data in the main form unless
I completley maximize that subform's' width and height to show as many fields
as possible.
 
R

Rick Brandt

MacNut2004 said:
I SEE the scrollbars...but what i'm saying is that the subform --
which is supposed to be viewd in datasheet view, is not being viewed
that way within the main form. I can't view ALL thte subform's data
in the main form unless I completley maximize that subform's' width
and height to show as many fields as possible.
Click to expand...

Do you have the default view of the form set to Datasheet?
 
M

MacNut2004

i have the default view of the SUBFORM set to datasheet, but not hte main
form because I have a drop down in the form header for the main form that i
want to show up.
 
Top