Hello
I use the following SQL-statement to fill a MSHFlexgrid
This causes the column to left-outlining nomatter how I try

SQL = "select Reken as Reken,format(Bedragv,'#0.00') as Lasyear


when I remove the format, the column is right-outlined. How come,
please help. I want it Right outlined, but allsod formatted to 2
decmials

thanks
Catharinus van der Werf
csvanderwerf@planet.nl

"catharinus" <csvanderwerf@planet.nl> wrote in message
news:3577f3bb-2264-44af-b9de-f085d1581055@21g2000yqj.googlegroups.com...
> Hello
> I use the following SQL-statement to fill a MSHFlexgrid
> This causes the column to left-outlining nomatter how I try
>
> SQL = "select Reken as Reken,format(Bedragv,'#0.00') as Lasyear
>
>
> when I remove the format, the column is right-outlined. How come,
> please help. I want it Right outlined, but allsod formatted to 2
> decmials
>

"Format" returns a "String".
You will need to pre-format or use the .ColAlignment or CellAlignment
methods.

-ralph

On 30 jan, 18:12, "Ralph" <nt_consultin...@yahoo.com> wrote:
> "catharinus" <csvanderw...@planet.nl> wrote in message
>
> news:3577f3bb-2264-44af-b9de-f085d1581055@21g2000yqj.googlegroups.com...
>
> > Hello
> > I use the following SQL-statement to fill a MSHFlexgrid
> > This causes the column to left-outlining nomatter how I try
>
> > SQL = "select Reken as Reken,format(Bedragv,'#0.00') as Lasyear
>
> > when I remove the format, the column is right-outlined. How come,
> > please help. I want it Right outlined, but allsod formatted to 2
> > decmials
>
> "Format" returns a "String".
> You will need to pre-format or use the .ColAlignment or CellAlignment
> methods.
>
> -ralph

He Ralph,

thanks, that I understood,
but MSHFLexgrid.Colalignment(1) doesn't change the outlining of the
column strangly enough.
I put the colalignment(1) statemen before and behind the format
statement and it doesn't change.

"catharinus" <csvanderwerf@planet.nl> wrote in message 
news:bb99feb0-5bb1-4003-b855-5566f22b610f@36g2000yqu.googlegroups.com...
> but MSHFLexgrid.Colalignment(1) doesn't change the outlining of the
> column strangly enough.
> I put the colalignment(1) statemen before and behind the format
> statement and it doesn't change.

What "1" stands for?

On 30 jan, 18:53, "Nobody" <nob...@nobody.com> wrote:
> "catharinus" <csvanderw...@planet.nl> wrote in message
>
> news:bb99feb0-5bb1-4003-b855-5566f22b610f@36g2000yqu.googlegroups.com...
>
> > but MSHFLexgrid.Colalignment(1) doesn't change the outlining of the
> > column strangly enough.
> > I put the colalignment(1) statemen before and behind the format
> > statement and it doesn't change.
>
> What "1" stands for?

Okay Friends

I took a break and some coffee. That's how one should do.
The 1 in the colalignment stands for the first column
You were right Ralph, the colalignment, I don't know why it works
right now, but it works. I must have done something wrong.
the statment for the colalignment:
mhslfexgridcolalignment(1)=7 repeated after the sql and it works

thanks
Catharinus van der Werf
csvanderwerf@planet.nl