Use of ~ tilde in a string 1

[scotttom]

I am trying to use a single tilde "~" as a string. I try to assign it to a variable and then I get an error "Invalid use of Null"

I suspect that the tilde is telling Access something other than simply "~".

Any ideas?

Thanks very much in advance for any help.

Scott

 

[Remou]

Could it be something else? It works ok for me, and is not in the:
Special characters that you must avoid when you work with Access databases

http://support.microsoft.com/?id=826763

How about (?):
Debug.Print Asc("~")
Or
Debug.Print Chr(126)

 

[scotttom]

Hi Remou,

I appreciate your help yet again. I haven't solved the other issue you have helped me with just got distracted.

So I have a combo that contains three columns, something like the following:

A | The letter A | Alpha
B | The letter B | Alpha
1 | The Number 1 | Number
~ | The Tilde | Special

I assign column 0 like this:

    Dim var As String
    
        var = Me![txtActivity].Column(0)
        MsgBox var

I get a message box with the correct character for all except the tilde. So I'm pretty sure that it is the tilde.

What am i missing?

Thanks again for your help!

Scott

 

[Remou]

I cannot get this to fail. :-(

 

[scotttom]

Remou,

Thanks for your help. Apparently using "Me![txtActivity].Column(0)" where that column is a special character by itself does not work. GO figure! I tried it with a few other characters and it did not work either. BUT when I made the bound column the description field it worked fine.

Thanks again.

Scott