Need help with left margin in Access Report

[voslica]

I have two text boxes (Text1 and Text2) in a report. When the value in Text2 = 0, I want the left margin of Text1 to change to a new position on the report.

I tried the code below:

If Me.Text2 = 0 Then
Me.Text1.Left = 3.5
Else
Me.Text1.Left = 2.5
End If

This didn't work. Does anyone know how to do this?

 

[macca the hacke]

I don't know how to do that, but I have another way round it. Why don't you have 2 text boxes on the report that are bound to the same data. You could hide/unhide these depending on value in Text2

 

[voslica]

Your suggestion worked. Thanks so much!