A
Archie
How do I pass an 'inverted comma' as a string using an
Input Box and Visual Basic?
Input Box and Visual Basic?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Ken Snell
You mean the ' character?
What do you mean, "pass it"? Give us an example of what you're trying to do.
What do you mean, "pass it"? Give us an example of what you're trying to do.
A
Archie
Thank you and a happy new year.
this value to the combo box?
combo accepting text in a form.I want to use an Input Box to set the default value in a
value enclosed in inverted commas.If the default value is not enclosed within " ", then an error results.
Trying to concatenate " does not work.
Alternately, the user can be asked to enter the default
automatically enclosed in inverted commas "", when passingMost users can be expected to forget / overlook this instruction.
Is there any way that the user specified text can be
this value to the combo box?
K
Ken Snell
If you want to do this in code, use a code step similar to the following:
Me.txtBoxName.DefaultValue = """" & _
InputBox("Enter the starting value for txtBoxName:") & _
""""
Or, you can use an expression similar to this in the Default Value property
of the text box (open form in design view, click on the textbox control,
open the Properties window, click on Data tab, and click in the Default
Value box):
=InputBox("Enter the starting value for txtBoxName:")
Me.txtBoxName.DefaultValue = """" & _
InputBox("Enter the starting value for txtBoxName:") & _
""""
Or, you can use an expression similar to this in the Default Value property
of the text box (open form in design view, click on the textbox control,
open the Properties window, click on Data tab, and click in the Default
Value box):
=InputBox("Enter the starting value for txtBoxName:")