How show & in Label component

[Bazsl]

I need to display some data generated in code in a Label component. The data contains an ampersand and the Label component converts the & to an underscore. Is there any way to disable this behavior for the Label component? If not, any workaround, possibly using a different component? Converting the & to && is possible as a last resort but I would rather not if there is another way? Can a TextBox be used as a non-data-bound component? If so, to which property to I assign the text to be displayed? Thanks.

[Missinglinq]

Converting the & to && is the only way I know to do this, with an actual Label.

You can set the Value of an Unbound Textbox using its Control Source Property, in the Properties Pane (Data Tab), like this:

= "This & That"

using the single Ampersand.

You can also tweak the Textbox to look more like a Label using its Special Effect Property (Properties - Format) setting it to Shadowed or Raised.

Linq ;0)>

[Bazsl]

I'm new to Access and confused about how to assign a value in a variable to the ControlSource property in code. Is the following the correct syntax?

[ATextBox].ControlSource = '="' & strVariable & '"'

Thanks.

[Micron]

FWIW, using && is called 'escaping' the character. While this might be true of other characters, the ampersand is the only one I know of that requires it. Using one & is for assigning a keyboard shortcut to activate the default event for the object. So if a command button has the caption &Open, the O (the letter immediately following the &) will be underlined in form view and Alt+O will select and 'click' the button. To have "Save & Close" as a button caption requires "Save && Close". An unattached label has events, but AFAIK, they're not available by a keystroke combination even though &MyField would show as MyField.

[Micron]

What is strVariable? You can't assign a sql statement to a textbox control source.
how to assign a value in a variable to the ControlSource property in code.What does this mean? In a procedure? In the property sheet as an expression?
Your variable should work in a procedure IF it holds the name of a field in the form's underlying record set regardless of whether or not the control is bound.
txtMyText.Controlsource = strMyString should work - no quotes, no extra = signs. At least it does for me if this is being done on the open event.