Automatically insert a straight line in access report if condition is met

[Access1983]

Hi,

I have an access form to take customer's orders. Once the order is complete before going to the next new order one must print the form into an access report which automatically saves it as pdf. Items in an order can differ from a standard box to an item sold by weight. Each box by weight has different weight and client is charged by kg and not by the number of cases. For such items by weight I would like to insert a line underneath in the report so that stores personnel can write down the weights by pen.

In the products table I have a particular column showing if the item is by weight or not. If the item is by weight is flagged Y and if not is flagged as N. So I need to create a solution so that in the report for every item inputted in the order which is flagged Y an extra line is inserted automatically in the report.

Thanks for your help.

 

[genomon]

Have a look at MoveLayout, NextRecord, PrintSection Properties of the report. It is pretty easy to use an If...Then in the detail print section to accomplish this. Something like:

    If fieldname = True  Then
        MoveLayout = True
        NextRecord = False
        PrintSection = True
    End If

Beir bua agus beannacht!

 

[genomon]

Oops I may have misread the post .
If you want a straight line and not a blank line, draw the line, and toggle its .Visible property on and off.

Beir bua agus beannacht!