If you are concantinating the line between several fields, you can use chr(13) & chr(10) that will that represents a next line. for example Award: [type] & chr(13) & chr(10) & 'in' & chr(13) & ohr(10) & [diploma study]
Hope this helps Thanks Eileen --- In [EMAIL PROTECTED], "ian_stevenson100" <[EMAIL PROTECTED]> wrote: > > HI everyone, > > I hope someone will be able to help me with this one as i'm pretty > new to using access. I am producing a report which prints out > various college awards a person has received. I am using a text box > to hold the award and have the property can grow set to 'Yes'.So it > looks like this > > Name : John Doe Year :2006 > > Award : Postgraduate Diploma in Addiction > Studies. > > What i want is have the layout of the Award to be like this > > Award : Postgraduate Diploma > in > Addiction Studies. > > So basically i want the words before the word "in" on a seperate > line and then the word "in" on a seperate line and then the rest of > the words after "in" to be on a seperate line. > > I hope i have explained my self correctly and any help would be > appreciated. > > Thank you >
