Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange character in string
Message
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Miscellaneous
Thread ID:
00568674
Message ID:
00568779
Views:
17
I have found two like this so far out of several thousand records.
The data is coming from a datacom database.
I could just remove the character with mid(), but how do I test to see if the first character is bad.
I tried:
If StrConv(Left(address, 1), vbFromUnicode) = ""
and it doesn't seem to work,

I also tried:
If Asc(rsNameData!Loc_Addr_1_Text) = 0
and that does seem to work,
will that be enough of a test?
Ryan
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform