I need to verify user name and password in a vb login form, using a recordset created by a query where the user name has to contain no spaces on the login form but some of the usernames in the access database table users contain a space.
userID UserName Password
1 JanetLeverling 81248
2 Margaret Peacock 19252
3 Steven Buchanan 30963
4 Michael Suyama 191037
5 Robert King 43550
6 Laura Callahan 276399
7 Anne Dodsworth 915899
any help would be appretiated
userID UserName Password
1 JanetLeverling 81248
2 Margaret Peacock 19252
3 Steven Buchanan 30963
4 Michael Suyama 191037
5 Robert King 43550
6 Laura Callahan 276399
7 Anne Dodsworth 915899
any help would be appretiated