Datagrid Column filled with multiple variables 1

[Genotix]

Hi guy's,

Is it possible to fill one column with multiple variables?
I want the column to display three fields from the same database table in one column.

As for now I can only enter one Datafield in the Property pages.

The entire field isn't editable.

Linux IS userfriendly.
It's only very selective about who it's friends are.

 

[Golom]

You could create a recordset as the datasource for the grid where you concatenate fields as in

Select (fld1 & fld2 & fld3) As ThreeFields, ...

From tbl

The result will be a non-updatable recordset.

 

[Genotix]

Great idea, stupid of me to didn't think of that!

It works like a charm!!
I used :

Select (fld1 & ' ' & fld2 & ' ' & fld3) As ThreeFields, ...

From tbl

So the fields were seperated from each other by a space.

Thanx a lot!

Linux IS userfriendly.
It's only very selective about who it's friends are.