Re: Subscript error in QR 6.5A

Hi John,

To verify just how large the data in the item number field is, use the Count(field) function in a formula (in the detail section) to verify the lengths of the item numbers. My guess is that one item in the data set has a length of less than 6 characters, thus causing the problem. You could also create a formula to label all of the records where this is true [If count(Item number)<6 then...].

When you determine the item number causing the problem, you will either have to modify your formula with the subscript to incorporate this data, or create a selection formula to dis-allow item numbers <6.

You probably should temporarily delete this formula while testing this out, so that the report can print.

If you have different length item numbers you can pad the formula with spaces and still use the subscript function.

E.g. (String + " ")[1 to 3] should always work even if String only has 2 characters, of course the third character returned will be one of your 'pad' characters.