Filling in blank textbox on a report.

[cowboy]

I have this code set up in the Detail_Format sub.

background on report:
Me!txtZA has the control source [Left Side Depth]
Me!txtZB has the control source [Right Side Depth]

What I want:
If [Right Side Depth] is empty I want it to show the same depth as the left side

Things I have tried:


If IsNull(Me![Right Side Depth]) Then
Me![Right Side DI Depth] = Me!txtZA.value
End If

If IsNull(Me![Right Side Depth]) Then
Me![Right Side DI Depth] = Me![Left Side DI Depth]
End If

If IsNull(Me![Right Side Depth]) Then
Me!txtZB.value = Me!txtZA.value
End If

Any help on this would be appreciated, thanks.

[RuralGuy]

Try:

If Len(Me.txtZB & "") = 0 Then
   Me.txtZB = Me.txtZA
End If

[cowboy]

I recieved an error
Run-time error '-2147352567 (80020009)':
You can't assign a value to this object.

[RuralGuy]

D'oh! You can't write to a bound control in a report! How about creating an unbound control and use similar code to populate it?
If Len(Me.txtZB & "") = 0 Then
Me.txtZC = Me.txtZA
Else
Me.txtZC = Me.txtZB
End If