Hi,

I am trying to get some text in a report column to match up so when I come to print it out it is all aligned.

Example:

At the moment it prints out like this in my Library No Column...

CD COM 655*17
CD COM 978* 2
CD2 COM 47* 4
CD COM 480* 5
CD1 COM 342* 1
CD2 COM 354*18

But I want it to look like this..

CD   COM 655*17
CD   COM 978* 2
CD2 COM 47* 4
CD   COM 480* 5
CD1 COM 342* 1
CD2 COM 354*18

When I'm typing the information in on the form, I am typing it in with the correct number of spaces that should make it look how I want it to look.  but it seems to be printing it out how it wants it to look.

The reports I am using have been translated from Q&A but I have created some new reports in Sesame but it still does the same.

Can anyone help me out on this one?

Many Thanks

Hello,

Is the value "CD COM 655*17" stored in one element on your form or is it stored in multiple elements?

If it is stored in multiple elements then you can align each one in the report by using the Look tab of the property editor. The Label Alignment is how you set the alignment of elements in a report.

-Ray

Hello,

In Designer
Open Your Report
Find the value box that displays the values in "Library No."
The value box will have a name displayed in square braces []. It may be something like LE11. Note this name
Click Program Layout. It is under commands on the left hand side.
In the first Drop down box choose the name that you just took note of.
Type the following code into the programming editor

ThisElement = @Replace(ThisElement, " ", " ") 

Save the report and run it.
Does it produce the desired results?

-Ray

Hi again Ray,

The program you gave me works fine but the only problem I have come across is that if I change the font in the "Library No." element the program no longer works and the "COM" is all over the place again.

The only font it works with is "Lucida Console".

Is it something I am doing wrong?

Manys Thanks.