2 column label report (advance)

[sonnierock]

Problem: Got a 2 column label report. Something like this when printed.
|---------------------|
|name1 name2|
|name3 name4|
|name5 name6|
|name7 name8|
|name9 name10|
|---------------------|

Then I have a form that have 10 combo box which draw its data from a table which contain of 100over names. Layout like the report.
|------------------------|
|combo1 combo2|
|combo3 combo4|
|combo5 combo6|
|combo7 combo8|
|combo9 combo10|
|------------------------|

Solution: The report print nicely when I select all 10 names. If I select only combo7 and want it to print at name7. Possible.

(Access default all blank combo as null and shift everything to top left column)

 

[tjs206]

Try setting the CanShrink property to yes for each field on the report (1 - 10).

The CanShrink property allows the field to shrink to nothing if there is not information, which removes the total space that the field would have required on the report, which in turn will keep moving the field up to the upper left hand corner if you have the columns set up correctly on the report.