JGravesNBS
Registered User.
- Local time
- Yesterday, 20:59
- Joined
- Apr 5, 2014
- Messages
- 58
Dim ProcAllowanceNew As Currency
Dim EffectiveDate As Date
The following code works OK if there are values in Column(13) & (14)
ProcAllowanceNew = Nz(Me.[strVADA].Column(13))
EffectiveDate = Nz(Me.[strVADA].Column(14))
If Column(13) & (14) are empty I'm getting Run-time error '13' Type mismatch
How can I adjust the two statements to handle the null values?
Dim EffectiveDate As Date
The following code works OK if there are values in Column(13) & (14)
ProcAllowanceNew = Nz(Me.[strVADA].Column(13))
EffectiveDate = Nz(Me.[strVADA].Column(14))
If Column(13) & (14) are empty I'm getting Run-time error '13' Type mismatch
How can I adjust the two statements to handle the null values?