I get the run-time error:
You entered and expression that has no value
Private Sub Report_Open(Cancel As Integer)
If [Text175] Like "" Then
Names, like Text175, can be tricky in Access if, as is usually the case, the name of the control is the name of a field. Such a name is technically ambiguous ("is it the name of a control or the name of a field?") and that can cause odd problems which are resolved by making the names slightly different.
Beyond this, say assuming that ambiguity is not the problem, do you know that the name would have a value associated with it at the time that Report_Open runs? Both "open" and "close"-type event handlers are classic for surfacing problems of this kind if they exist.