Solved Form Display Question

[jo15765]

I am setting the source of a form as a query that holds roughly 30 lines

How can I set the form to display one horizontal row, per row in the query just like the query does?

I tried setting it to continuous, but that stacked all the query fields vertical on top of each other and spanned several "pages" down on the form

 

[Minty]

It's known as a tabular continuous form design, the wizards can make a good stab at creating one, but you'll almost certainly need to edit it to get it exactly how you want.

 

[theDBguy]

I am setting the source of a form as a query that holds roughly 30 lines

How can I set the form to display one horizontal row, per row in the query just like the query does?

I tried setting it to continuous, but that stacked all the query fields vertical on top of each other and spanned several "pages" down on the form

Hi. As Minty was saying, you could try this:

1. In Design View, set the Default View to Single Form
2. Select all the controls on your Form's Detail section (that is, all controls selected at the same time)
3. From the Ribbon > Arrange > Table Group > Tabular
4. Adjust as desired and save

Hope that helps...