If Statement Not Triggering On Change Of Page Number S’abonner
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")))
value = Field("Field5")
Thanks a lot,
Vous devez vous connecter pour laisser un commentaire.