INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Access Howto:

Finding ascii values within strings or fields by mdav2
Posted: 6 Feb 01

The following syntax should help you to search for those irritating characters such as double quotes (") within a field or string.  

If InStr(1, field or string, character to search for, vbTextCompare) Then
    .... code that you want to run if character found
End If

EG.

This searches for a " in the field called address1 on the active form.  Try to use the ascii characters when searching for single characters.  Please refer to DougP's FAQ to find a list of ASCII characters (1a in the FAQs).  I have not tried to look for larger strings so I am not sure if it would work for them.  

If InStr(1, Me!Address1, Chr(34), vbTextCompare) Then
    MsgBox "invalid character found"
    varContinue = False
End If

Back to Microsoft: Access Other topics FAQ Index
Back to Microsoft: Access Other topics Forum

My Archive

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close