If Statement Not Triggering On Change Of Page Number S’abonner

0
Avatar
Legacy Poster

Hello,

 

I am trying to use an If statement to set the quantity field on the last page to a different value to all the other pages.

The If statement does not seem to recalculate on change of page however.

I am Using the "Copies" value in the Print Dialog to duplicate the number of labels by a database field.  This works fine and the page numbers increment properly.

 

My formula bleow works, but does not seem to re-evaluate properly within the one record of the text file.

Does anyone know if I am supposed to use an alternative event to OnProcessData or something to make it work?

 

 

If Format.Objects("PageNum").Value = FormatNumber(Field("JobLabelQty"),0) Then

 value = (Field("Field7") - ((Field("JobLabelQty") - 1) * Field("Field5")))

Else

 value = Field("Field5")

End If 

 

 

Thanks a lot,

 

Vous devez vous connecter pour laisser un commentaire.