Form Questions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have 3 questions on forms that I would like help with:
1) While in design view, I have a form that has a lot of information and I
am not able to lengthen the form by dragging the bottom part down. I think it
has reached it's maximum length for a page. Can I increase this size, or set
it to display on a new page?
2) When I try to set the background color of a form, by using fill/back
color, the change is not updated.
3) In my form, I am requiring that users select answers form a drop-down
list, how am I able to set this up?

Any help with the above questions, would be greatly appreciated.

Thanks!
 
Lucy said:
Hi,

I have 3 questions on forms that I would like help with:
1) While in design view, I have a form that has a lot of information
and I am not able to lengthen the form by dragging the bottom part
down. I think it has reached it's maximum length for a page. Can I
increase this size, or set it to display on a new page?
Click to expand...

The maximum height of any section of a form or report, and the maximum
width, is 22 inches. It's unusual to have a real need to exceed this;
in fact, even a height of 22 inches is cumbersome to work with. I
suggest you use a tab control on your form, and put different controls
on each page of the tab control, organized logically.

Incidentally, there's a trick to moving existing controls from the body
of the form itself to a tab page. You must select the controls and
"cut" them from the form, then click on the tab to select the page you
want, and then "paste" the controls. If you don't do it that way, you
usually end up with the controls sitting back on the form itself, not on
the tab page at all.
2) When I try to set the background color of a form, by using
fill/back color, the change is not updated.
Click to expand...

I don't have that problem at all. What exactly are you doing to set the
back color? You can't set this for the whole form, of course, just for
each section of the form.
3) In my form, I am requiring that users select answers form a
drop-down list, how am I able to set this up?
Click to expand...

You should probably have a table to hold the possible answers, and make
that table, or a query of it, the RowSource of your combo box. I
couldn't say more than that without more information.
 
Back
Top