Adding strings together

[jobro]

So I need to know this. How do I:

*Add 2 text fields together with a space between?
*Truncating field 1 to the first character and field 2 to the two first characters?


Sorry for my noob questions

 

[Friday]

So I need to know this. How do I:

*Add 2 text fields together with a space between?
*Truncating field 1 to the first character and field 2 to the two first characters?


Sorry for my noob questions

field1 & " " & field2

Left(field1,1) Left(field2,2)

 

[jobro]

Care to explain a bit further? Because when I do this then all I get is #Error when I'm trying to print it in a report.

 

[boblarson]

If you want your field in a report you need to add it to the controlsource like this:

=Left([Field1InBrackets],1) & " " & Left([Field2InBrackets],2)

 

[jobro]

Ok so here is my control source as it is now:

=[Förnamn] & " " & [Efternamn]

just to simplify the process. Giving this control source gives me an error while giving another reference to another field gives me the result.

 

[Friday]

Ok so here is my control source as it is now:

=[Förnamn] & " " & [Efternamn]

just to simplify the process. Giving this control source gives me an error while giving another reference to another field gives me the result.

Are Förnamn and Efternamn both fields in the underlying data source?

 

[boblarson]

Also, check to see that the field name and the text box that is bound to each of those are not the same. When using calculations in controls (or concatenations), you will run into errors if they are the same.