Displaying Multible Colums On One Form

[Guest]

Hi, I am new to Access and I was wondering how to show many colums and have
the form grow to that size.

Ex:
Form Header
**********************************
* HEADER Title *
**********************************

Detail

Colum1
Colum2
Colum3
Colum4
Colum5
Etc.


Form Footer:

Close button




I have the form set to: continuous form
Auto Fit = yes

Only to colums show up yet there are other records still to show. If I
resize the form it shows the other record I want the form to grow to around 8
Colums.

Is there a way to do this Thank You!

 

[John W. Vinson]

Hi, I am new to Access and I was wondering how to show many colums and have
the form grow to that size.

Ex:
Form Header
**********************************
* HEADER Title *
**********************************

Detail

Colum1
Colum2
Colum3
Colum4
Colum5
Etc.


Form Footer:

Close button




I have the form set to: continuous form
Auto Fit = yes

Only to colums show up yet there are other records still to show. If I
resize the form it shows the other record I want the form to grow to around 8
Colums.

Do you mean *columns* or *rows*? Your example shows rows, and a continuous
form shows both multiple columns and multiple rows.

I suspect what you need to do to see additional rows in your continuous form
is to move all the textboxes and other controls snug up against the top of the
Detail section, and then drag the bottom of the detail section snug up against
the bottom of the controls. You should be able to get upwards of twenty rows
visible - eight should be no problem.

If you do mean (vertical) columns... please explain.

John W. Vinson [MVP]

 

[Guest]

Hi, and thank you for any help. I did as you said and now I only have 4
showing yet there are 6 more to be shown.

1.) Continuous form
2.) Form footer has one blank line and then I have to click on buttons
3.) autoresize on the form = yes
4.) not opening in Docmd.maxium
5.) Dividing line = no

Also another form (that I am trying to do the same thing) has only one row
showing and it has the same as above.

Right I am dealing with ROWS.

Thank You for any help!

 

[John W. Vinson]

Hi, and thank you for any help. I did as you said and now I only have 4
showing yet there are 6 more to be shown.

1.) Continuous form
2.) Form footer has one blank line and then I have to click on buttons
3.) autoresize on the form = yes
4.) not opening in Docmd.maxium
5.) Dividing line = no

Also another form (that I am trying to do the same thing) has only one row
showing and it has the same as above.

Right I am dealing with ROWS.

Thank You for any help!

Well, I can't see your screen so I don't know what the problem might be. Can
you resize the entire form to make it bigger? Or resize the detail section? Is
there a big blank space visible in form view that's not there in design view,
or what?

John W. Vinson [MVP]

 

[Guest]

Hi, and thank you for helping.

When I resize (in detail view) and then I open in form view there is a large
blank section. If I resize (in form view) it shows the records that I want
to display automaticily. So yes I can resize to make it bigger.

I don't know of a way to send you the pictures of the screens/forms...

So I will have to kind of draw something close to what I am getting:

Detail Section
Row1
Row2
Row3
Row4
---------- Below -This section is not showing------------------------
Row5
Row6
Row7
Etc.

What I want is:
Row1
Row2
Row3
Row4
Row5
Row6
Row7
Etc.
-------------- Then the bottom of the screen/form --------------------------

Thank You for any help...

 

[John W. Vinson]

Hi, and thank you for helping.

When I resize (in detail view) and then I open in form view there is a large
blank section. If I resize (in form view) it shows the records that I want
to display automaticily. So yes I can resize to make it bigger.

I don't know of a way to send you the pictures of the screens/forms...

I'm really curious, and would be willing to stretch a rule and provide some
offline support here. Drop me an email at jvinson <at> wysard of info <dot>
com (edit out the blanks and do the obvious punctuation) if you're interested.

John W. Vinson [MVP]

 

[Guest]

Hi, thanks again for your help. I solved the problem. I did not use a
subform. The previous programs used subforms and sometimes not (looks like
it was created by several persons). I don't know how they get the info to
show up before. All I did was to change font size (something larger) and I
could not get it to do what they had done. They had no subform within the
form before yet the user could see the records. But when I changed fonts
this did not happen anymore so I had to create subforms.

Thank you for any help....