Contact US

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.

Students Click Here

Microsoft: Access Other topics FAQ

1. ASCII Table

Where can I find all of the ASCII characters by DougP
Posted: 12 Dec 00

There is a WEB page I put in my favorites


1 = SOH
2 = STX
9 = TAB
27 = ESC
34 = " (Double quote)
39 = ' (single quote)
A = 65

How to use this in Access:
The above numbers are usually put in Chr$(xx)
 & Chr$(13) ' would add a Carriage return to a line.
Example of how to add a carriage return, line feed to a message box:
    Dim MyString As String
    MyString = "this is Line 1" & Chr$(13) & Chr$(10)
    MyString = MyString & "This would be line2" & Chr$(13) & Chr$(10)
    MyString = MyString & "And this is line3"
    MsgBox MyString, vbInformation, "Multi-Line Example"

sometimes itÆs necessary to add single quotes to a SQL statement
    Dim MySQL As String
    MySQL = "Select * From MyTable Where MyField = " & Chr$(39) & SomeVariable & Chr$(39)

So Chr$(39) is a single quote

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

My Archive

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