Steve: Yeah, that sucks. There was a point in 6.5++ where this started
happening. In previous builds, it would "reserve" space for null values but
starting with one build it started closing up those spaces. I remember that
I
did not upgrade one of my clients to that build because she had SO many
chooses that could have null values I decided I didn't want to "fix" my code.
But in any case, you have to put this "ifnull" test in there for any of your
columns that you believe might be null. Here's a sample of columns that you
know will not be null and some that might be. I put a period within the
quotes. I kow that a space didn't work but can't remember if I tested putting
in a
char(255) (hard space) to see if that worked.
CHOOSE vAsk FROM #VALUES FOR ( +
LJS( CompanyName,35) & +
LJS( IFNULL(city,'.',city),15) .....
Karen
> Buddy
>
> Got headings great but if there is no data in a column the data all
> shifts to the left and the data does not line up under the proper
> headings.
>
> Any ideas?
>
> CUSTOMER# CONTACT EXT MOBILE HOME A
> ORDER
> <NEW>
> <VIEW OR EDIT ALL>
> MT0001M FRANK MUSTO 1 314-239-7097 314-239-7097 Y
> 1
> MT0001M DEB KREIENDER NONE Y 2
> MT0001M BOB NORRIS NONE Y 3
>
> Steve
