column size

[collinm]

hi

i display result query with:

CurrentDb.QueryDefs("qryTest").SQL = strQuery
    DoCmd.OpenQuery "qryTest", acViewPreview

are there a way to set column size for every field?

thanks

 

[wazz]

Me.ControlName.ColumnWidths "0cm;2cm;3cm;"

something like that. you might have to fool with syntax a bit.
just realized you're probably not talking about a form-control. sry, not sure if it's possible.