Have report print "Bin x of y"

[Hillary]

I have a form where the user enters the total number of parts per lot and number of parts per bin. I have a formula that calculates the number of bins needed. (ex. 1000 pieces per lot and 25 pieces per bin. The formula calculates 40 bins.)

In this case I will need to print 40 labels(1 for each bin). I can do that through a macro. What I need help with is I want each label to print "Bin x of y" where y is the total number of bins (40 in this case) and x is 1 through 40.

I have never used VB code before.

Thanks for your help!

Hillary

 

[GingerR]

how big are your labels? are they one per sheet? why i am asking is if they are one lable per sheet of paper (as opposed to like having 30 lables on a 8.5" x 11" sheet) then you can just use this format in a text box in the page footer:

="Page " & [Page] & " of " & [Pages]

but make it bins instead.

="Bin " & [Page] & " of " & [Pages]

but if you have a mulitple labels on a piece of paper let me know and we will figure it out.

 

[Hillary]

That's what I ended up doing. Thanks for you help!