Variable width text box in a report

[JLevi]

I am trying to create a report with several text boxes on a line. The data from each field is variable in length and I need the spacing between the last character in one text box to be only one space from the first in the next text box. Is there a way to have the text box be variable in width? i.e. I now have:
Acer rubrum-----------------------L.

I need:
Acer rubrum-L.

(---) represents spaces

Notice that I have 2 different font formats so I can't have both in the same text box.

Thanks,

JL

 

[JLevi]

I am new to this forum and by no means an Access expert, but is my previous post question solveable? Any advice will be much appreciated. JL

 

[boblarson]

Looks like you need a single text box and use concatenating in the underlying query to create that one field to bind to that text box.

 

[JLevi]

As a non-expert (very limited programming experience) in Access, could you elaborate on this or are you aware of any examples I could look at? The data is coming from 2 seperate columns in a table. How would I concatenate and bind to a single text box? Thanks again for your advice.

 

[boblarson]

In the query, you create the field yourself by using something like this (replace my names with your actual field names):

MyNewFieldName:[Field1] & " " & [Field2]

And then you would make the text box the width of the report and set its control source to MyNewFieldName (remember you will use your own names here, I just put these as examples). Also set the CAN GROW AND CAN SHRINK properties of both the text box and the section the text box is in to YES.

 

[JLevi]

I have been pulled away on other projects, but have finally gotten back to this.

I am having trouble getting the report to display the query results in a text box while other text boxes are pulling data from a table. Is there a way around this?

Also, if I get this to work, will I be able to have 1 text box display italic and non-italic fonts? i.e. Acer rubrum L. This has ultimately been my main problem.

Thanks,
JL

In the query, you create the field yourself by using something like this (replace my names with your actual field names):

MyNewFieldName:[Field1] & " " & [Field2]

And then you would make the text box the width of the report and set its control source to MyNewFieldName (remember you will use your own names here, I just put these as examples). Also set the CAN GROW AND CAN SHRINK properties of both the text box and the section the text box is in to YES.