Inserting Pipe Character into Access97 Field

[YoungBuck]

How would I go about inserting a pipe character into a normal Access97 text field? I have tried all the obvious ways using two pipe characters || prepending the pipe character with a backslash \| , but I still continue to get Error 3075, invalid use of vertical bars.

[ViagraFalls]

Uhm. Why on earth would you want to use two pipe symbols in the first place?

[YoungBuck]

I am just trying to insert a single pipe-character into an access db, but when I execute an Insert Into query using one (i.e.: INSERT INTO tblUsers(UserID, Password, UserLastName, UserFirstName, UserMiddleName) VALUES ('ldh', 'Â&|óϾã¼ï', 'Harrell', 'Lisa', 'Deanne'))
I get error 3075 w/the message "invalid use of vertical bars". Those were the two methods I've already tried, escaping the pipe with another pipe character (the same way you have to do for the single quote ' character) and escaping the pipe with a backslash (read that somewhere). Any ideas?

[Beacon]

Yeah use the ascii character instead i dont know what it's ascii character number is but this is how to use it:

Dim quote As String
quote = Chr(34)
 
rsTEXT = "rs.Open" & quote & "SELECT etc etc etc

This would insert quotations!

If you find the relavent character you can use it that way!

ciao
b

[YoungBuck]

That was the trick I was looking for, thanks Beacon.

[wherewasi]

Young Buck,

Can you show me the code that worked... it's ASCII Char 124... but I'm getting errors. I need to do this to create mainframe JCL on the fly.... any help is appreciated.

Thanks,

Tom