Showing data horizontally in a sub form

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

Guest

I have got two fields to show in a sub form. By default, sub-form binds data
vertically like this:

Color : White
Color : Black
Color : Blue
Color : Green
Color : Orange

I want to show sub-form to show these fields in the following way:

Color : Color : Color : Color : Color
White: Black : Blue : Green: Orange


- Imtiaz Qamar
 
I have got two fields to show in a sub form. By default, sub-form binds data
vertically like this:

Color : White
Color : Black
Color : Blue
Color : Green
Color : Orange

I want to show sub-form to show these fields in the following way:

Color : Color : Color : Color : Color
White: Black : Blue : Green: Orange


- Imtiaz Qamar
Click to expand...

What determines how many records are displayed on the subform? Is it
always exactly five?

Typically a Subform displays the "many" side of a relationship. In
principle your subform could have 31228 records... you'ld need a
rather wide monitor! More seriously, if it has a *variable* number of
records you'll need special handling.

What is the *real life* situation? Would a Crosstab query be a
possible solution?

John W. Vinson[MVP]
 
Back
Top