Need help with a Grid

[GubertDisentis]

I have an application with a MSFlexGrid.
In Grid(col1) there is a name.
In Grid(col2) there is .txt
How can I create a col3 which combines col1 with col2
Col3 should then read name.txt

I tried
Grid1(Col13)= Grid1(Col1) + Grid1(Col2)
After I replaced the + with & but nothing works.

What is wrong ?

Your help is apprciated

 

[tedsmith]

If there is an SQL statement for the grid you can change your fields for firstname and secondname to one field and edit the design of your grid.
Instead of two fields ([firstname]),([Secondname]) you say ([Firstname] & " " & [Secondname])
But of course you can't make changes to data unless you change the original database to one combined field.

 

[ArtieChoke]

How did you create the grid? Is it bound to a database? If not, then just add another column and use the textmatrix property to add the column value.

"I think we're all Bozos on this bus!" - Firesign Theatre