VBA codes with repeated rows in report

[Esmatullaharifi]

Hi!
I have used

If  Len(Result.Value) > 7 then
Result.TopMargin = 0
End If

vba code but it is applying to all rows whenever one of rows located in repeated area of report make condition true. How to solve this issue.

[ItsMe]

Use additional details. If you format a control, the property will be represented each time the control is displayed in that group/detail.

[pbaldy]

As answered elsewhere:

I'm not clear on what you're trying to do, but code like that would need to be in the format event of the detail section, and would need an Else clause to set the property when the value wasn't greater than 7.

cross posters