Adding static text to textbox that displays input data

[Guest]

I have a textbox control that shows me the input the user entered before
running the report (Control source: "[Forms]![UnivCriteriaFrm].[txtFrom]" )
..

How can I add the word "From" in that same textbox? I tried it this way,

Control Source -> ="From: "+[Forms]![UnivCriteriaFrm].[txtFrom]

but I get "#Name?" in the report where the 'From...' should be. What's
wrong?

Thanks.

 

[Wayne Morgan]

Try

="From: " & [Forms]![UnivCriteriaFrm].[txtFrom]

don't forget a space on each side of the &.

 

[Guest]

It still didn't work. In Control source, I typed:

="From: " & [Forms]![UnivCriteriaFrm].[txtFrom]

and I still get "#Name?" in the space where the info should be.

But if I only write:
Forms!UnivCriteriaFrm.txtFrom

it displays it correctly.
What could it be?

VM

Try

="From: " & [Forms]![UnivCriteriaFrm].[txtFrom]

don't forget a space on each side of the &.


--
Wayne Morgan
Microsoft Access MVP

I have a textbox control that shows me the input the user entered before
running the report (Control source: "[Forms]![UnivCriteriaFrm].[txtFrom]" )
.

How can I add the word "From" in that same textbox? I tried it this way,

Control Source -> ="From: "+[Forms]![UnivCriteriaFrm].[txtFrom]

but I get "#Name?" in the report where the 'From...' should be. What's
wrong?

Thanks.

 

[Wayne Morgan]

Good question, because if I leave out the =, then I get #Name?. I have to put in the = and
when I do, Access automatically puts in the brackets.

The only thing I can think of is that the field and the text box on UnivCriteriaFrm are
BOTH called txtFrom and so Access doesn't know which to use.