Hi everyone,

Is there an easy way to right justify an alpha field in a define? I know you can do this in the style settings but was hoping something like:

fieldname/A4R

would work. I also know I could change the A4 to an I4 to accomplish but I need the field to be an alpha format.

Thanks for any suggestions.

Can't you use the RJUST function?

RJUST would right justify the data in the field, but what format is your output to be in? That can affect how things are displayed no matter what you do.

You can use RJUST, but if you output in HTML or EXCEL it won't by right-justified. However in PDF, it will.

The final output will be in .txt format. Seems like there would be an easy way to do this in the define but I have yet to find. Keep the suggestions coming! Thanks!

Forgot to mention...I'm trying the RJUST now and will let you all know if that works.