Run time error 438 object doesn't support this property or method

[riaarora]

Dear Friends,

I'm getting below error while using MS Flex Grid

Run time error 438 object doesn't support this property or method.

I have registered "Microsoft FlexGrid Control 6.0 (SP3)" but still getting this error.

Below is the code I'm using:

'MS Flex Grid Control used to create the form/grid


Private Sub InitProc()
txtSearch.Value = ""
MSFG1.ColWidth(0) = 0
MSFG1.ColWidth(1) = 1500
MSFG1.ColAlignment(1) = 0
MSFG1.ColWidth(2) = 4500
MSFG1.ColAlignment(2) = 0
MSFG1.ColWidth(3) = 1500
MSFG1.TextMatrix(0, 1) = "User ID" 'Assign the value of "User ID" Field
MSFG1.TextMatrix(0, 2) = "User Name"
MSFG1.TextMatrix(0, 3) = "Status"
End Sub

OS: Windows XP
MS Access: 2003

Thanks in advance for the help.

Regards
Ria

[boblarson]

Access doesn't support the use of the MSFlexGrid.

[riaarora]

Hi Bob

Thanks for the quick reply. Actually this was working in my old desktop with same configuration. But somehow it it's not working in my new desktop.

Regards
Ria

[boblarson]

Am surprised it was ever working because I get an error message that states that Access doesn't support that control. And that is in Access 2003 SP3.

[riaarora]

Seems this well known issue but noone have the solution for this... If you search on net you'll find lot of talk going on from last couple of years but no solution...

I have tried lot of options but none of them is working...

Does anyone know of a replacement for MsFlexGrid that has similar functionality... I'm happy to change the code as well...