Getting text to line up in text boxes

[colmoore]

Hi there,

I am making a report which details the title, first name and surname of members of a club.

I have 3 fields TITLE,FIRST NAME,SURNAME.

I have them displayed on the report, but the problem is because each is in its own text box, the words are spread out, like:

MR<big space>JOHN<big space>SMITH.

Does anyone know how you can make it read MR JOHN SMITH???? Is it possible to do it like a mail merge in Word and put all 3 fields in one text box???

Thanks in advance.

Col

 

[richary]

You'll need something along the lines of

[TITLE] & " " & "[FIRST NAME]" & " " & [SURNAME]

as the control source for a text box you place on the report

 

[colmoore]

Done it!

Richary,

Thanks very much

Cheers
Col