Chance1234
IS-IT--Management
Its monday is all i can say im trying to strip out postal codes from fields in my Access DB, trouble is the postal codes are all different lengths
here is the code i have but its not working :-(
'----------- --------------------------------------------PO BOX Fields----------------
If ChkCnt <> 9 Then
If Left(StRflDs(ChkCnt), 2) = "PO" Then
PosChk = InStr(8, " ", StRflDs(ChkCnt), vbTextCompare)
StRflDs(9) = Left(StRflDs(ChkCnt), PosChk + 1)
StRflDs(ChkCnt) = Right(StRflDs(ChkCnt), Len(StRflDs(ChkCnt) - PosChk))
End If
End If
here is the code i have but its not working :-(
'----------- --------------------------------------------PO BOX Fields----------------
If ChkCnt <> 9 Then
If Left(StRflDs(ChkCnt), 2) = "PO" Then
PosChk = InStr(8, " ", StRflDs(ChkCnt), vbTextCompare)
StRflDs(9) = Left(StRflDs(ChkCnt), PosChk + 1)
StRflDs(ChkCnt) = Right(StRflDs(ChkCnt), Len(StRflDs(ChkCnt) - PosChk))
End If
End If