Data formatting problem

Hello,

I'm looking for solutions to a formatting problem.

I have two stand alone textboxes on a report body that I would like to have display side by side with very little white space between them.

Example: TextBox 1 contents (variable length) = "Muddy Waters"

Textbox 2 contents (variable length) = "B.Sc"

Current display:Muddy WatersB.Sc

Desired display:Muddy Waters B.Sc

Here is my problem.

Simple concatenation of values into 1 textbox would work if the font size and font family were the same for both textboxes; unfortunately this isn't the case. The font size and family for each textbox is different. Is there a richtext control I can place on the report and load with preformatted rich text?

Any suggestions would be appreciated.

Thanks,

Roy M

Hi,

Try making the first textbox right-aligned & the second textbox left-aligned. It might possibly solve your problem.

Just an idea

-Aayush

|||

1.Put both of the textboxes adjacent to each other .

2.Apply Font size and style.

3.Use Padding left for the second text box.

Hope this will solve your problem.

|||Thanks, but this won't work as I need to keep things left aligned.|||

Do they have to be separate textboxes? The easiest thing would be to replace the two with a single one, replacing the content with the values from both fields as follows:

Code Snippet

=Fields!Field1.Value & " " & Fields!Field2.Value

If your textboxes are in a table, select them both and right click for the context menu and choose 'Merge Cells' and do the same.

Good luck,

Larry|||

This won't work as the text formatting for both fields needs to be different.

Thanks anyway.