Quotation marks in a txtbox

[way2bord]

How do I put

""

into a form text box?

 

[bob fitz]

Try:
Me.[TxtBoxName] = """" & """"

 

[boblarson]

You can also use

Me.TextBoxNameHere = Chr(34) & Chr(34)

 

[way2bord]

update:

How do I allow a USER to input, in form view, a value of

""

into a text box.

 

[boblarson]

update:

How do I allow a USER to input, in form view, a value of

into a text box.

They should be able to if the field the text box is bound to is a TEXT or Memo datatype. Nothing special needed there. What is it to designate? Why would they be putting that in there?

 

[way2bord]

They should be able to if the field the text box is bound to is a TEXT or Memo datatype. Nothing special needed there. What is it to designate? Why would they be putting that in there?

Primarily, it's a personal pet peeve for txt boxes which should be unrestricted as to input. Chances that an end-user would ever enter a double quotation? ...slim to none. But they should have the ability to enter it.

If I wanted to have the text box unbound, is there any way to designate it as a "Text" or "Memo" type?

 

[boblarson]

Primarily, it's a personal pet peeve for txt boxes which should be unrestricted as to input. Chances that an end-user would ever enter a double quotation? ...slim to none. But they should have the ability to enter it.

If I wanted to have the text box unbound, is there any way to designate it as a "Text" or "Memo" type?

What I guess I was thinking is that it should be fine. But I just tested and it does appear that it thinks you are entering an "Empty String." So it just shows as blank. So, it is interpreting it as an empty string which, in VBA is "" so again I will ask, "Why would someone type that in there?"

 

[way2bord]

What I guess I was thinking is that it should be fine. But I just tested and it does appear that it thinks you are entering an "Empty String." So it just shows as blank. So, it is interpreting it as an empty string which, in VBA is "" so again I will ask, "Why would someone type that in there?"

Currently, I just wanted to treat an unbound text box as a memo field -
with zero restrictions to what an end-user could input.

In the application it was going to be a password field that would accept all input, no matter how ridiculous.

In truth, I can't imagine a great reason why someone would ever type "" in a field. It was more of a momentary thought experiment.

 

[boblarson]

Well, it does look like it does translate that to an empty string. Two single quotes work, two double quotes work as long as there is something else in the control even if it is just a space.