M
Mohican
I am relatively new to VBA, but can manage to work through some basic issues.
However, I am receiving the following error message when I click on the
command button of a form:
Run-time error '2427
You entered an expression that has no value
When I run degug, the following code appears:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Dim ssn As String
If Len([SS#].Value) = 9 Then <-This is the line that debug highlightes in
yellow
ssn=[SS#].Value
End If
If Len([SS#].Value) = 8 Then
ssn = "0" & [SS#].Value
End If
If Len([SS#].Value) = 7 Then
ssn = "00" & [SS#].Value
End If
HoldSSN.Value=ssn
End Sub
I did not create this application, but am confused at how best to resolve
this problem. Any help would be greatly appreciated.
However, I am receiving the following error message when I click on the
command button of a form:
Run-time error '2427
You entered an expression that has no value
When I run degug, the following code appears:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Dim ssn As String
If Len([SS#].Value) = 9 Then <-This is the line that debug highlightes in
yellow
ssn=[SS#].Value
End If
If Len([SS#].Value) = 8 Then
ssn = "0" & [SS#].Value
End If
If Len([SS#].Value) = 7 Then
ssn = "00" & [SS#].Value
End If
HoldSSN.Value=ssn
End Sub
I did not create this application, but am confused at how best to resolve
this problem. Any help would be greatly appreciated.