print "special" characters

[chewy]

How would I be able to print out

If MsgBox(""" & Me.CustomerID.Text & "" is not in the list!" & vbCrLf & "Add it?", vbOKCancel, "Add New Customer Confirmation") = vbOK Then

I want to put the CustomerID in quotes

 

[Mile-O]

try using Chr(34)

i.e.

If MsgBox(Chr(34) & Me.CustomerID & Chr(34) & " is not in the list!" & vbCrLf & "Add it?", vbYesNo, "Add New Customer Confirmation") = vbYes Then

 

[chewy]

cool thanks that worked. But I thought there was some character to put infront of it to make it print the following character

 

[The_Doc_Man]

After a while, all the double and triple quotes get boring. Here is what I do...

Dim stQuest as String
Dim stTitle as String
Dim inAnsw as Integer

stTitle = "{" & Me.Customer & "} is not in the list"
stQuest = "Add new customer? "

inAnsw = MsgBox( stQuest, vbYesNo, stTitle )

...

Think SIMPLE.

 

[mission2java_78]

If (MsgBox("CustomerID: '" & Me.cboCustomer.Column(0) & "' is not in the database!",vbExclamation, "Not In!")=vbYes) then


Jon