Name and Address in same textbox

[bobsyeruncle]

How can i display Name and address in the same box on my report? They are stored in two seperate fields in the table.

The box has a border so i cant just sit a 'name' textbox on top of the address one.

I am assuming i am being pretty thick!

 

[PNGBill]

How can i display Name and address in the same box on my report? They are stored in two seperate fields in the table.

The box has a border so i cant just sit a 'name' textbox on top of the address one.

I am assuming i am being pretty thick!

You can concatenate the data.

This can be done by sql, by DLookup and a few more.

I have just done one where few labels are used because I concatenated the label with the data. Don't do this with data you later want to use with other calculated controls.

DLookup("[fieldname1]&" "&[fieldname2]","Sourcetable or SQL","Criteria if used")

 

[Kryst51]

Is the report based on a query? If so you can concatenate the two fields in the query under an alias, then use the alias on your report instead.

Concatenation