Expert: Scottgem - 2/21/2005

Question
Scottgem -

You didn't say how experienced you are with Crystal Reports, but I'm hoping you have more experience than I.  Here's my question:

I am using a formula to produce several different headings for the same column (depending on the invoice number).  However, I am trying to bottom align all my headings, which are two lines, and one of the options in my formula is too short and keeps ending up on the top line.  Is there any sort of vertical alignment option where you can force a text field to stay aligned to the bottom no matter how large it is (like in Office)?  I can't find one and I'm not sure what to do now.

Help!
Lorena Kerr

Answer
I checked and don't see anyway to format a textbox for vertical alignment.

There might be a way to fudge this though. Since you are using a formula to determine the heading, you could include a Line feed with headings that will fit on one line. You could concatenate in a Asc(10) or Asc(13) in front of the text to force a line feed.

HTH
Scott<>

P.S. You might have to use the Char function instead of the Asc function. I didn't test this, but the concept should work.