Parts bin labeles

[weymes]

I am trying to create a label for parts bins.



each bin has 1 - 5 items

each item has a unique location (IE. AB01C02) Called Loc

A B 01 C 02
Isle Bay Shelf Box Slot

label looks like the following

*Label header*
=Left([Loc],4)

*Detail*
=Right([Loc],2)*+* PartNo *+* Description

when i set it up like this and adjust the Row Height I only get one piece of info per label and if i dont adjust the row height then i just get a grouped report

How can make the label look like the following

AB01C

01 *+* PartNo *+* Description
02 *+* PartNo *+* Description
03 *+* PartNo *+* Description





AB01D

01 *+* PartNo *+* Description
02 *+* PartNo *+* Description
03 *+* PartNo *+* Description
04 *+* PartNo *+* Description



AD01E

01 *+* PartNo *+* Description
02 *+* PartNo *+* Description

[trevor40]

Quick tip, don't use the header section, just detail.

[weymes]

Quick tip, don't use the header section, just detail.

Sorry but i am still a nuwbe when it comes to access how is that going to be any different. If i alter row hight i still only get 1 record per label. how can i get all records for the box on one label?

[trevor40]

Sorry but i am still a nuwbe when it comes to access how is that going to be any different. If i alter row hight i still only get 1 record per label. how can i get all records for the box on one label?

have you set your printer paper, margins,columns,size.
a change in row hight indicates a size/layout missmatch,
to test set all text boxes to say fontsize 8, then select all text boxes and double click to resize them, if you see all fields on the print preview then adjust the sizes to suit.
also check you have data in all text boxes as expected
if needed i could post a sample label printer db