Full_Williams
Registered User.
- Local time
- Today, 23:49
- Joined
- Jul 2, 2002
- Messages
- 88
Hi,
I've searched thru the forums, but haven't found any problem similar to mine.
I'm trying to strip a field of spaces...certain fields have one space as the string and the code doesn't seem to recognize these fields. If str = " " the code doesn't recognize it. Here it is:
str = rst0![SchoolComments]
If lenstr = "" Then
rst0.Edit
rst0![SchoolComments] = Trim(str)
rst0.Update
ElseIf lenstr = " " Then
rst0.Edit
rst0![SchoolComments] = Trim(str)
rst0.Update
End If
Has anybody ever had this problem? Any suggestions would be appreciated.
Thanks,
Full Williams
I've searched thru the forums, but haven't found any problem similar to mine.
I'm trying to strip a field of spaces...certain fields have one space as the string and the code doesn't seem to recognize these fields. If str = " " the code doesn't recognize it. Here it is:
str = rst0![SchoolComments]
If lenstr = "" Then
rst0.Edit
rst0![SchoolComments] = Trim(str)
rst0.Update
ElseIf lenstr = " " Then
rst0.Edit
rst0![SchoolComments] = Trim(str)
rst0.Update
End If
Has anybody ever had this problem? Any suggestions would be appreciated.
Thanks,
Full Williams