Help with reports Detail_format
Posted on 2013-11-12
Hello, I'm trying to use the following to conditionally populate a txt box on a report.
I'm getting the error: you can't assign a value to this object
What is the method and syntax to do this sort of thing in Access VBA?
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If CCur(Me.txt_ExtCostSubTotal) > CCur(50) Then
Me.txt_Administration = 500
Me.txt_ExtCostSubTotal = 0