'不用绑定方式显示记录集 with mshflexgrid for i=1 to .rows-1 for j=0 to .cols-1 .textmatrix(i,j)=rs.fields(j).value next next end with'处理楼主的问题 with mshflexgrid for i=1 to .rows-1 .textmatrix(i,n)=iif(textmatrix(i,n)="-1","默认","不默认") 'n为字段所在列的列号 next end with
在打开记录集的时候写成 strsql="select 其它字段, case 字段 when -1 then '默认' else '不默认' end as 字段 from invcdtl adodc1.RecordSource=strsql
with mshflexgrid
for i=1 to .rows-1
for j=0 to .cols-1
.textmatrix(i,j)=rs.fields(j).value
next
next
end with'处理楼主的问题
with mshflexgrid
for i=1 to .rows-1
.textmatrix(i,n)=iif(textmatrix(i,n)="-1","默认","不默认") 'n为字段所在列的列号
next
end with
strsql="select 其它字段, case 字段 when -1 then '默认' else '不默认' end as 字段 from invcdtl
adodc1.RecordSource=strsql