Change Position Text Field Follow

0
Avatar
Legacy Poster

In the attached btw vb scripting is used to change the Y position of "Tekst 4" to the Y position of "Tekst 3" if "Tekst 3" is empty.

The value of "Tekst 3" is loaded from a MS SQL database field.

 

If Format.Objects("Tekst 3").Value = "" Then
msgbox "ja"
    Format.Objects("Tekst 4").Y = Format.Objects("Tekst 3").Y
    Format.Objects("Tekst 5").Y = Format.Objects("Tekst 3").Y
Else
msgbox "nee"
End If

 

But this isn't working, the position isn't changed when I move to the next record.

1 comments
0
Avatar
Shotaro Ito
Comment actions Permalink

it looks script itself is fine - When I open document, Tekst 4 moved up a bit.

Because Tekst 3's reference point is mid left and Tekst4's reference point is top, tekst 4 climb up to half the height of the tekst 3. 

 

Besides, If you want to skip line when no data from field, consider to have a multiline text with some data sources connected.

[

datasource1 : <FIELD1>

datasource2 : <<CR>> Suppress when previous datasource is empty

datasource3 : <FIELD2>

datasource4 : <<CR>> Suppress when previous datasource is empty

datasource5 : <FIELD3>

]

<<CR>> can be entered from Ω button > Control characters.

Please sign in to leave a comment.