Want to prevent duplicate entery including extra/less spaces.
with follwoing code, duplicate entery is prevented including case sensitity.
I am wondering if it is possible to prevent with extra or less space. For example: Test1 or Test 1
1st one has no space, 2nd one has space. is it also possible to prevent this, if user manupulate a word while data entery.
My current code is
Thanks
with follwoing code, duplicate entery is prevented including case sensitity.
I am wondering if it is possible to prevent with extra or less space. For example: Test1 or Test 1
1st one has no space, 2nd one has space. is it also possible to prevent this, if user manupulate a word while data entery.
My current code is
Code:
If Not IsNull(DLookup("[Catalogue]", "ArticleDetails", "[Catalogue] = '" & Me.txtCatalogue.Value & "'")) Then
Cancel = True
Msgbox "msg for duplicate"
Else
End if