Is it possible to show multiple fields in a single text box in a report? I have separated an adress line in 2 different fields, but id' like to show them in a single line, preferably in the same textbox, without having a white space between the two...
I read a couple thing about it in the forum, and help files but nothing really answered my question.
My guess is its prolly possible by changing the control source of my textbox in the textbox properties by inserting something like... =[adr post 1] & [adr post 2] ... but nothing is working yet,
One reason why this may not have worked is, if you add fields to your report from the field list the default name is the name of the field. So the text box name would be 'adr post 1' in your example. If you then changed the Control Source to the above Access gets confused because you could be referencing the text box 'adr post 1' of the data in the field 'adr post 1'. I would bet that if you changed the name of the textbox (Name property in the Other tab) that the above would work for you. When you see Name? instead of the result you were expecting then first think typo then think name of the control.
My other suggestion would be to add a space between the two with: