System_Acronym value is populated
System_Name is not populated
I'm trying to get the CaptureName code to run and while it knows that Me.System_Name is null, it's erroring on this line.
The code needs to handle situations where the system name is null.
The code compiles.
System_Name is not populated
I'm trying to get the CaptureName code to run and while it knows that Me.System_Name is null, it's erroring on this line.
The code needs to handle situations where the system name is null.
The code compiles.
Code:
CaptureName = StrConv(Trim(ReplaceIllegalChars(Me.System_Acronym)), vbUpperCase) & IIf(IsNull(Me.System_Name), " ", " (" & StrConv(Trim(ReplaceIllegalChars(Me.System_Name)), vbProperCase) & ")")