How to GIve Format to the data in mshflexgrid?

that can be done directly by using sql statment

try like this

select id,name, '$.' ||salary as sal from employee

Yes, but shouldn't Format function also work in SQL?

Yes, but shouldn't Format function also work in SQL?

Yes ,but you need to format the string before passing to SQL and processing or first fetch from sql and then format as per your requirment.

Hi,

How you are populating the MSHFlexGrid..? Setting DataSource or Open Recordset and Loop Through and add row by row..?

If using second method then, you can populate the textmatrix with the formatted String :
If using First method, then
After Binding to the datasource, Just loop through all the Rows and Format:
Regards
Veena

Yes ,but you need to format the string before passing to SQL and processing or first fetch from sql and then format as per your requirment.

No, I mean can't you include Format() function in SQL? I thought Access SQL at least, had a Format function for just this kind of situation.

Ok, I've just checked. Here's some SQL which I built in the Access Query Designer. It works, displaying the numeric field aaa as six digits.

SELECT Format([aaa],"000000") AS Um FROM Table1;

I entered the values 1, 2, 3 and 28000 in field aaa, then ran this query. Here's the output...

Um
000001
000002
000003
028000

Hi,

For Access Database, Directly Change the SQL Statement:

"Select Field1,Format(AmtField,'##,###.00') As MyAmtField From MyTable"

Regards
Veena