Switch from Single Form to Continuous Form view

[D Riggins]

Is there a method or property that can be manipulated with VBA to switch a
form from Single form view to Continuous forms view (and vice versa) without
first switching to design veiw?

 

[Albert D. Kallal]

I don't think so....

However, to really lay out your form in a nice looking way, you're likely
not going to be able to have a nice looking continuous form, and then have a
really nice decent be easy to use form to edit the data at the same time.

You can however switching between form and datasheet mode.

In most cases, what I do is build a continuous form, and then place it
button in the detail section that repeats, and when the button is clicked on
it launches the detail form. This allows the user to click on a button and
see a form, edit the data, and then close that form. The person is thus
returned right back to where they were on the continues form.

Take a look at the following screen shots, and you'll see how often I place
a button that simply when clicked on launches a detail form.

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

 

[D Riggins]

Thanks,

I want to avoid the pop-up form. I was looking to to have a continuous form
that shows basic identifying data for each record in the details section and
addtional details displayed in the form footer. The form footer would only
be revealed/hidden using a command button.

I wanted to prevent users from scrolling and navigating in the continuous
form while the footer is still visible.

 

[Graham Mandeno]

You can certainly have bound controls in the header and/or footer of a
continuous form, and these will show data from the current record.

You can make the footer visible or invisible:
Me.Section(acFooter).Visible = True (or False)

You can adjust the overall height of the form (if required) with
Me.InsideHeight.